Actions7
Row → Read Rows
AI-generatedSummary
Reads data from a specific worksheet in an Excel file, returning rows as JSON items starting from a specified row index.
Inputs
- inputMode (required) — How to provide the Excel file: 'File Path' uses a local path, 'Binary Data' uses a binary property from a previous node.
- filePath (required) — Absolute path to the Excel file (required when inputMode is 'filePath').
- binaryPropertyName (required) — Name of the binary property containing the Excel file (required when inputMode is 'binaryData').
- sheetName — Name of the worksheet to read from. If not specified, the first worksheet is used.
- startRow — Row number to start reading from (1-based, defaults to 2 to skip the header).
- endRow — Row number to stop reading (0 means read all rows to the end).
- includeRowNumber — Whether to include a '_rowNumber' field in the output for each item.
Output shape
a list of items, each containing JSON data matching the worksheet columns
Empty rows are skipped. When using file path mode, changes are saved to disk if 'Auto Save' is enabled.
Examples
Example 1: Read all data from a worksheet, skipping the header
Input Mode: File Path, Sheet Name: [Selected], Start Row: 2, End Row: 0, Include Row Number: false
Example 2: Read a specific range of rows (e.g., rows 5-10)
Input Mode: File Path, Sheet Name: [Selected], Start Row: 5, End Row: 10, Include Row Number: true
Example 3: Read data from a binary Excel file attached to a previous node
Input Mode: Binary Data, Binary Property: 'data', Sheet Name: [Selected], Include Row Number: false