Actions9
Read Rows
AI-generatedSummary
Read worksheet rows as JSON items, optionally filtering them by column values. The operation also returns the workbook as binary data on each output item.
Inputs
- Sheet Name — Worksheet to read; leave empty to use the workbook’s first sheet.
- Filters — Add conditions with a column header and value. A row is returned only when every condition matches; comparisons also match values with the same string representation. Leave empty to return all rows.
- Input Binary Field — Binary property containing the XLSX workbook, default
data. The node loads the first input item that has this property; if none does, it reads from a new in-memory workbook. - Output Binary Field — Binary property for the resulting XLSX file, default
data. - Output File Name — Filename attached to the resulting XLSX binary data, default
spreadsheet.xlsx.
Output shape
One output item per matching worksheet row, with the row’s non-empty header names as JSON keys. Each item also carries the serialized workbook in the configured binary property.
Rows start at row 2; row 1 supplies the headers. Blank header columns are omitted, and date cells are returned as ISO strings. If no rows match, the operation returns one item with an empty JSON object and the workbook binary.
Examples
Example 1: Read every row from the first sheet
Leave Sheet Name and Filters empty; provide the workbook in the data binary property.
Example 2: Read rows where status is active
Add a filter with Column status and Value active.