Read all sheets from an Excel file in a loop
This workflow demonstrates how to read all sheets from an Excel (.xlsx) file using the Excel Reader node together with the Read Excel Sheet Names node in a loop.
To read all sheets from an .xlsx file, first add the Read Excel Sheet Names node to the workspace and chose the appropriate .xlsx file from the file system in the configuration dialog. The node lists all sheet names from the selected .xlsx file together with the file path in a data table.
This table is used to feed the Table Row to Variable Loop Start node which takes one row from the data table in each loop and creates a flow variable from it. In the loop, the created flow variables are fed into the Excel Reader node. The Path variable to specify the file location and the Sheet variable to specify which sheet to access.
The Loop End node collects all the sheets by appending the rows.