.xlsx and .xls files. It works the same way as the CSV Reader but for spreadsheet files.
Configuration
| Option | Description | Default |
|---|---|---|
| Source | Upload to load a local file, URL to fetch from a web address | Upload |
| File | The Excel file to upload | — |
| URL | A direct link to a publicly accessible Excel file | — |
| Sheet Name | The name or index (0-based) of the sheet to read | 0 (first sheet) |
Input / Output
| Type | |
|---|---|
| Input | None |
| Output | DataFrame |
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.