Get Rows from Excel

Overview

The 'Get Rows from Excel' action obtains and returns rows as JSON from the file provided.

Input File Types

The following file types are supported:

• XLSX
• XLS
• CSV

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.

Parameters

The default 'Get Rows from Excel' flow action parameters are detailed below:

• File Content: A Base64 encoded representation of the Excel file to be processed

File Contents

Please refer to the Obtaining the 'File Contents' Parameter article for guidance on how to obtain the 'File Content' parameter ready to provide to an Encodian flow action. 

Advanced Parameters

The advanced 'Get Rows from Excel' flow action parameters are detailed below:

• Worksheet Name: Set the name of a specific worksheet to be exported
• Has Header Row: Set whether the worksheet has a header row
• First Row: Set the number of the first row to be exported
• Last Row: Set the number of the last row to be exported
• First Column: Set the number of the first column to be exported
• Last Column: Set the number of the last column to be exported
• Exclude Empty Rows: Set whether empty rows should be excluded from the export
• Export Empty Cells: Set whether empty cells should be exported
• Export Values as Text: Set whether values should be exported as text, i.e. a number would be exported as "value":"3" and not "value": 3
• Hyperlink Format: Set how Hyperlinks should be exported
• Export as Object: Force row data to be exported as a JsonObject even when there is only a single worksheet contained within the file
• Culture: 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 'Get Rows from Excel' flow action returns the following data. 

Standard Return Values

• Row Data - A JSON string representing the extracted rows
• 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.