Read all sheets from an XLS file in a loop

This workflow demonstrates how to read all sheets from an XML file using the XML Reader node together with the Read XLS Sheet Names node in a loop.

To read all sheets from an .xls file in a loop first add the Read XLS Sheet Names node to the workspace and chose the appropriate .xls file from the file system in the configuration dialog. The node lists all sheet names from the .xls file 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 variable is fed into the XLS Reader as SHEET_NAME.

The Loop End node collects all the sheets by appending the rows.

External resources

• Excel Reader