.xlsx and .xls files. It works the same way as the CSV Reader but for spreadsheet files.
Configuration
Input / Output
Notes
- Only one sheet is read per component. To load multiple sheets, add multiple Excel Reader components and connect them with a Concatenate component.
- Merged cells and non-tabular formatting in your spreadsheet may cause unexpected results. Use a clean, flat table layout.