Merge Excel Files

Overview

The 'Merge Excel Files' flow action merges up to 1,000 Microsoft Excel files (and related formats) provided in a JSON array to a single file. 

This action takes all worksheets contained in multiple Excel files and places them as separate worksheets within a single Excel file. To illustrate:

INPUT

Excel 1
  - Tab a
  - Tab b
Excel 2
  - Tab c

OUTUT

Merged Excel
  - Tab a
  - Tab b
  - Tab c

To merge multiple worksheets into a single worksheet, please refer to our Merge Excel Rows action.  

Input File Types

The following file types are supported for files to be merged:

  • XLSX
  • XLSB
  • XLST
  • XLSM
  • XLS
  • CSV
  • tabdelimited
  • ODS
  • spreadsheetml
  • TSV

Output File Types

The merged output can be saved in any of the following file formats:

  • PDF
  • CSV
  • TIFF
  • XLSX
  • XLS
  • XLSB
  • XLSM

Example Flows

Please refer to the following article showcasing the 'Merge Excel Files' action

Power Automate Templates

Default Parameters

The default 'Merge Excel Files' flow action parameters are detailed below:

  • Filename: The filename of the output excel file
  • Output Format: The format of the output excel file
  • Documents: The array of files to be processed

As a manually entered array:

  • Filename: The filename of the source file (including the file extension)
  • File Content: The file content of the source file
  • Sort Position: Set the sort position for the document within the array, lowest number first.
  • Worksheets to Merge: Specify which worksheets from the source file should be included within the output

As an array object:

Documents - JSON Schema 

The JSON provided within the documents parameter should conform to the following schema:

{
"fileName": "<Filename including extension>",
"fileContent": "<File contents (Base 64 string)>",
"sortPosition": <Optional - Sort position number>,
"worksheetsToMerge": [<Optional - int array>]
}

Return Parameters

The 'Merge Excel Files' flow action returns the following data. 

Action Specific Return Values

  • File Content - The processed file (Base64)

Standard Return Values

  • OperationId - The unique ID assigned to this operation.
  • HttpStatusCode - The HTTP Status code for the response.
  • HttpStatusMessage - The HTTP Status message for the response.
  • Errors - An array of error messages should an error occur.
  • Operation Status - Indicates whether the operation has completed, has been queued or has failed.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk