Merge Excel Files

Overview

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

Input File Types

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

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

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

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: A Base64 encoded representation 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

mceclip1.png

As an array object:

mceclip0.png

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