Consolidate Multiple Excel Files into One – KNIME Community Hub

KCH Workflows
1

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.

This is a companion discussion topic for the original entry at https://hub.knime.com/-/spaces/-/latest/~-ydjwcLiby44IfMT/
2

Hi,

i used this workflow to consolidate 3 Excel Files, in each Excel File ist one sheet. The workflow ist working, but at the end in the new written consolidated Excel File there is only one sheet, the other two sheets are missing. I think the problem is in the Excel writer cause there is only shown that Excel File which is consolidated at the End.

Anyone has a Hint for me to solve this problem?

Thanks.