Excel line reader
Read an Excel file line by line. For example:
| A | B | C |
|-----------------------------|
1 | header1 | header2 | header3 |
2 | data1A | data1B | data1C |
3 | data2A | data2B | data2C |
4 | data3A | data3B | data3C |
|-----------------------------|
| SHEET_1 | SHEET_2 |
Sheet name: SHEET_1
Start line: 2 (starting reading from line 2)
Preload lines: 1 (adds a "Line: 1" output holding line 1, available on every read line)
Parameters
The name of the Excel sheet to read. The name must match exactly; if no sheet with that name exists, the run fails with an error listing the available sheet names.
The line number to start reading from, counted from 1. Both 0 and 1
read the whole sheet; 2 skips the first line (typically the header
row).
The lines to load and keep in memory to be used on each line read. (For
example, you can load the first line and use it on line 2, 3, 4, etc.)
Each preloaded line N adds a dedicated output connector labeled
Line: N that carries that row alongside every read line. A line number
out of the sheet's range yields an empty object.
Preloading only works when the file is small enough to be read in memory: on the streaming path used for large files, preload lines are ignored and the extra connectors stay empty.
Output
The current row being read from the Excel sheet, as an object keyed by
column letter (A, B, C…).
The preloaded row N, emitted with every read line. Empty when the line
is out of range or when the file was streamed.