Excel - Separate Worksheets

Power Automate Connector: Encodian – Excel

Overview

The 'Excel - Separate Worksheets' Power Automate action enables you to extract specified worksheets from the Excel file provided.

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 - Separate Worksheets' flow action parameters are detailed below:

• File Content: The Excel file to be processed.

  

Advanced Parameters

The advanced 'Advanced Parameters

The advanced 'Excel - Add Rows' flow action parameters are detailed below:

• 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 - Separate Worksheets' flow action returns the following data. 

• Action Specific Return Values

• Files - The collection of files extracted from the Excel file provided

  Each file within the files collection contains the following values:

• Files Filename - The filename of the file. This is the worksheet name from the input file. 
• Files File Content - The file content of the file

• 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.