Extract Data
AI-generatedSummary
Extract JSON data from a specified sheet within an Excel file provided in binary form.
Inputs
- Binary Property (required) — The name of the binary property on the incoming item which contains the Excel file to process.
- Sheet Name (required) — The name of the sheet within the Excel file from which to extract data.
Output shape
a list of JSON objects representing the extracted data rows from the specified sheet
The extracted data is returned as JSON. Each item corresponds to a data row or structured JSON element extracted from the sheet. If an error occurs and continueOnFail is enabled, error details are returned instead in JSON format.