How to Merge Multiple Excel Workbooks Into One File via API

Описание и применение

API PDF4me позволяет объединить несколько файлов 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

Источник