Excel - Merge Worksheets

*** Available from June / July 2026 ***

Power Automate Connector: Encodian – Excel

Overview

Input File Types

The following file types are supported:

• XLSX
• XLSB
• XLSM
• XLS

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different numbers of credits. Please always check the action-specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Default Parameters

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

• File Content: The Excel file to be processed

Advanced Parameters

The advanced 'Advanced Parameters

The advanced 'Excel - Merge Worksheets' flow action parameters are detailed below:

• Primary Worksheet: Set the name of the worksheet to merge into. If left empty, the worksheets will be merged into the first worksheet
• Worksheets to Merge: Specify a comma-separated list of worksheet names to merge. If left empty, all worksheets will be merged
• Include First Row: Set whether to include the first row of the worksheet. The default value is 'False'
• Delete Merged Sheets: Set whether the source worksheets are deleted after merging. The default value is 'False'
• Convert Expressions to Values: Set whether to convert expressions to values
• Culture Name: This setting is used to set the culture for the workbook prior to conversion. Please refer to the Culture Names article for a list of supported cultures.

Return Parameters

The 'Excel - Merge Worksheets' 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 been completed, has been queued or has failed.