Excel - Extract Worksheets

Overview

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