Icon

Read all sheets from an excel file

This workflow reads all sheets from a Excel file by using a loop. The Loop End node collects all the sheets by appending the rows.

Read excel fileAppend all sheetstogetherLoop over sheetsRead each sheetRead ExcelSheet Names Loop End Table Row ToVariable Loop Start Excel Reader Read excel fileAppend all sheetstogetherLoop over sheetsRead each sheetRead ExcelSheet Names Loop End Table Row ToVariable Loop Start Excel Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: soumyabrata.ghosh
Created at: 2021-11-04
On NodePit since: 2021-11-04
Last update: 2024-11-23
Created with KNIME version: v4.4.1
Tags: exceldata wrangling

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!