Icon

Consolidate_​Multiple_​Excel_​Files_​into_​One 1

Consolidate Multiple Excel Files into One

This workflow demonstrates how to bring multiple Excel files in one Excel file with multiple sheets. After Files are listed file names are extracted in String Manipulation node and will be used as Sheet names in consolidated Excel file. Both input and output files are located in the data folder within the workflow directory and workflow relative paths are used.

Consolidate Multiple Excel Files into OneThis workflow demonstrates how to bring multiple Excel files in one Excel file with multiple sheets.Forum link: https://forum.knime.com/t/excel-consolidation-multiple-excel-files-to-one-excel-with-multiple-worksheets/31485 Read ExcelStart Loop per each FileWrite to new Sheet in each iterationDummy Loop EndNode 8result.xlsxNode 15Node 16Node 17Node 18 Excel Reader Table Row ToVariable Loop Start Excel Writer Variable Loop End Read ExcelSheet Names Excel Sheet Appender(XLS) (deprecated) URL to FilePath (Variable) String Manipulation(Variable) String Manipulation(Variable) Loop End Consolidate Multiple Excel Files into OneThis workflow demonstrates how to bring multiple Excel files in one Excel file with multiple sheets.Forum link: https://forum.knime.com/t/excel-consolidation-multiple-excel-files-to-one-excel-with-multiple-worksheets/31485 Read ExcelStart Loop per each FileWrite to new Sheet in each iterationDummy Loop EndNode 8result.xlsxNode 15Node 16Node 17Node 18 Excel Reader Table Row ToVariable Loop Start Excel Writer Variable Loop End Read ExcelSheet Names Excel Sheet Appender(XLS) (deprecated) URL to FilePath (Variable) String Manipulation(Variable) String Manipulation(Variable) 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: Johnny
Created at: 2019-01-03
On NodePit since: 2022-12-12
Last update: 2024-04-27
Created with KNIME version: v4.7.0
Tags: Excel FilesFile ManipulationData Consolidation

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

Try NodePit Runner!