Extract Excel Worksheets

** AVAILABLE APRIL 2024 **

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

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.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk