PDF4me Excel icon

PDF4me Excel

Revolutionize Excel workflows with intelligent automation: dynamically manipulate spreadsheets, merge data seamlessly, secure files with enterprise-grade encryption, and extract insights through advanced row operations - all powered by cutting-edge PDF4me API technology

Merge Files

AI-generated

Summary

Merge multiple Excel files into a single workbook, optionally specifying files by binary data, base64 content, or URL, with control over their order and specific worksheets to include.

Inputs

  • Files to Merge (required) — Add one or more Excel files to merge, each with input method (binary data, base64 string, or URL), optional filename, sort position (merge order), and optional specific worksheet names (comma-separated) to merge from that file.
  • Output Format (required) — Select the format of the merged output file: XLSX, XLS, PDF, or CSV.
  • Output File Name (required) — Provide the filename (without extension) for the merged output file.
  • Output Binary Data Name (required) — Set the property name under which the merged file's binary data will be stored in the workflow output.

Output shape

a single binary file

The output contains the merged Excel file in the chosen format as binary data under the configured binary data property name. The filename uses the provided output file name plus the appropriate extension. Errors may be returned if input files are invalid or incompatible.

Discussion