Icon

31485-looping-through-excel-sheets

read file namesfrom folderextract XLSsheets(per file)start firstloop(through file names)start second loop(through sheetsper file)importExcel SheetsendsecondloopendfirstloopList Files/Folders Read ExcelSheet Names Table Row ToVariable Loop Start Table Row ToVariable Loop Start Excel Reader Loop End Loop End read file namesfrom folderextract XLSsheets(per file)start firstloop(through file names)start second loop(through sheetsper file)importExcel SheetsendsecondloopendfirstloopList Files/Folders Read ExcelSheet Names Table Row ToVariable Loop Start Table Row ToVariable Loop Start Excel Reader Loop End Loop End

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: m1pegv
Created at: 2021-03-16
On NodePit since: 2021-03-16
Last update: 2024-05-01
Created with KNIME version: v4.3.2

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

Try NodePit Runner!