Read
AI-generatedSummary
Read data from a specified Excel file and worksheet, optionally restricted to a given cell range, returning each row as an individual output item with column headers as keys.
Inputs
- File Name (required) — Select the Excel file on the server to read from, either from a searchable list or by specifying the exact filename.
- Sheet Name — Select the worksheet within the Excel file to read, either from a list or by exact name; can be left empty to default.
- Range — Specify the cell range to read (e.g., A1:D10). Leave empty to read all data in the sheet.
Output shape
a list of items, each with a JSON object representing one row from the Excel sheet, with keys as column headers
If the read data includes valid headers, rows are transformed into JSON objects mapping headers to values. If data is missing or minimal, an empty data array with success true is returned. The operation returns an error if required parameters are missing or if API calls fail.