How to Merge Multiple Excel Workbooks Into One File via API

说明与用途

PDF4me API 可将多个 Excel 工作簿合并为一个文件，消除手动错误并节省时间。

问题

Monthly close requires merging five regional Excel files into a single master workbook, a task that is error‑prone when done manually.

结果

The API merges multiple Excel workbooks in the order specified, resolves sheet name conflicts, and returns a single merged file in Base64, reducing manual effort and errors.

工作流

• 1. Encode each source workbook to Base64.
• 2. Build JSON payload with "mergeFilesToExcelAction", including "documents" array and optional "outputFileName".
• 3. POST to /ApiV2Excel/ExcelMergeFiles with appropriate headers.
• 4. Receive JSON response containing Base64‑encoded merged workbook.
• 5. Decode and write the merged file to disk.
• 6. Verify success flag and handle errors.

证据

PDF4me's Excel Merge Files API handles this as a single HTTP call.

来源

The request body, exactly as documented on the Merge Files Excel API page

来源

The response comes back as JSON with document (the merged workbook, Base64-encoded), fileName, success, and errorMessage.

来源

If you're not writing a custom integration, the no-code platform versions of this action expose more control than the bare REST contract above

来源