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.
Workflow
Consolidate Multiple Excel Files into One
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.3.2
Legal
By using or downloading the workflow, you agree to our terms and conditions.