Icon

kn_​forum_​27953_​loop_​multiple_​excel_​files

Loop thru same Excel sheet names from various sources and collect them back

Loop thru same Excel sheet names from various sources and collect them back

Loop thru same Excel sheet names from various sources and collect them backhttps://forum.knime.com/t/multiple-excels-files-with-multiple-sheets/27953/13?u=mlauber71 with deprecated nodes list excel files/data/read sheet namescollect sheet namesSTARTURLcollect sheet namesENDOuterGroupLoopSTARTreadsheet(deactivate evaluationto allow various structures)Extract path informationsexctractpropertiesfrom filesInner Loop perSheet TypeENDURLfile_namev_tableInner Loop perSheet TypeSTARTconstructfilenamesheet_namev_tableOuterGroupLoopENDextractfile informationsURIRead the result in sheet aRead the result in sheet blist excel files/data/collect sheet namesSTARTread sheet namesURLcollect sheet namesENDOuterGroupLoopSTARTSheetexctractpropertiesfrom filesextractfile informationsconstructfilenamev_tableresult_sheet2Inner Loop perSheet TypeSTARTcollect sheet namesENDreadsheet(activate changing file schemas)URLfile_namesheet_namev_tablev_tableOuterGroupLoopENDRead the result in sheet aresult_sheet2_a.tableRead the result in sheet bresult_sheet2_b.tableList Files(deprecated) Read Excel Sheet Names(XLS) (deprecated) Table Row To VariableLoop Start (deprecated) ConstantValue Column Loop End(deprecated) Group Loop Start Excel Reader (XLS)(deprecated) URL to File Path URL to File Path Loop End(deprecated) ConstantValue Column ConstantValue Column Java EditVariable (simple) Table Row To VariableLoop Start (deprecated) Table Row to Variable(deprecated) Row Filter ConstantValue Column Table Writer(deprecated) Variable Loop End(deprecated) File MetaInfo (legacy) String to URI Path to String Table Reader(deprecated) Table Reader(deprecated) List Files/Folders Table Row ToVariable Loop Start Read ExcelSheet Names ConstantValue Column Path to URI Loop End Group Loop Start URL to File Path Files/FoldersMeta Info Row Filter Java EditVariable (simple) Table Rowto Variable Table Row ToVariable Loop Start Loop End Excel Reader ConstantValue Column ConstantValue Column ConstantValue Column Table Writer String to Path(Variable) Variable Loop End Table Reader Table Reader Loop thru same Excel sheet names from various sources and collect them backhttps://forum.knime.com/t/multiple-excels-files-with-multiple-sheets/27953/13?u=mlauber71 with deprecated nodes list excel files/data/read sheet namescollect sheet namesSTARTURLcollect sheet namesENDOuterGroupLoopSTARTreadsheet(deactivate evaluationto allow various structures)Extract path informationsexctractpropertiesfrom filesInner Loop perSheet TypeENDURLfile_namev_tableInner Loop perSheet TypeSTARTconstructfilenamesheet_namev_tableOuterGroupLoopENDextractfile informationsURIRead the result in sheet aRead the result in sheet blist excel files/data/collect sheet namesSTARTread sheet namesURLcollect sheet namesENDOuterGroupLoopSTARTSheetexctractpropertiesfrom filesextractfile informationsconstructfilenamev_tableresult_sheet2Inner Loop perSheet TypeSTARTcollect sheet namesENDreadsheet(activate changing file schemas)URLfile_namesheet_namev_tablev_tableOuterGroupLoopENDRead the result in sheet aresult_sheet2_a.tableRead the result in sheet bresult_sheet2_b.tableList Files(deprecated) Read Excel Sheet Names(XLS) (deprecated) Table Row To VariableLoop Start (deprecated) ConstantValue Column Loop End(deprecated) Group Loop Start Excel Reader (XLS)(deprecated) URL to File Path URL to File Path Loop End(deprecated) ConstantValue Column ConstantValue Column Java EditVariable (simple) Table Row To VariableLoop Start (deprecated) Table Row to Variable(deprecated) Row Filter ConstantValue Column Table Writer(deprecated) Variable Loop End(deprecated) File MetaInfo (legacy) String to URI Path to String Table Reader(deprecated) Table Reader(deprecated) List Files/Folders Table Row ToVariable Loop Start Read ExcelSheet Names ConstantValue Column Path to URI Loop End Group Loop Start URL to File Path Files/FoldersMeta Info Row Filter Java EditVariable (simple) Table Rowto Variable Table Row ToVariable Loop Start Loop End Excel Reader ConstantValue Column ConstantValue Column ConstantValue Column Table Writer String to Path(Variable) Variable Loop End Table Reader Table 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: A9699459
Created at: 2020-10-13
On NodePit since: 2020-10-13
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: excelloopsheetssheetnamefileinformation

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

Try NodePit Runner!