Icon

kn_​forum_​51793_​consolidate_​multiple_​excel_​files_​into_​one

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 with data in line 9Start Loop per each File Write to new Sheet in each iterationsim.xlsxvar_sheet_selectionNode 18sheet_nameExcel Reader Table Row ToVariable Loop Start Excel Writer Read ExcelSheet Names Java EditVariable (simple) Loop End ConstantValue Column 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 with data in line 9Start Loop per each File Write to new Sheet in each iterationsim.xlsxvar_sheet_selectionNode 18sheet_nameExcel Reader Table Row ToVariable Loop Start Excel Writer Read ExcelSheet Names Java EditVariable (simple) Loop End ConstantValue Column

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-20
Last update: 2024-05-01
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!