Extract Excel Worksheets

Overview

The 'Extract Excel 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
• XLS

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number 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 'Extract Excel Worksheets' flow action parameters are detailed below:

• File Content: A Base64 encoded representation of the Excel file to be processed.
• Worksheet Names: A comma separated list of the names of the worksheets to extract: Sales, Totals, Year to Date
• Worksheet Indexes: A comma separated list of indexes of the worksheets to extract: 1,3,4

Return Parameters

The 'Extract Excel 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.