Create individual excel files from multiple worksheets

[lazaronewhall17]

Good afternoon,

I have a file with multiple worksheets that I would like to split(save) into different files. Is this a possibility?

In the attached file I have 3 tabs (A, B and C) I would like to have a flow that can save them in individual excel files.

Knime Sample.xlsx (10.8 KB)

Thanks for the support

Laz

[mlauber71]

@lazaronewhall17 yes this can be done. With such tasks you can combine several nodes into a system to handle your files.

You read the Excel Sheet names and feed them into a Table Row to Variable Loop start to iterate over them (you can expand this obviously to several files).

You create Path variables for a new sub-folder:

Using the name of the “Sheet” as Folder name from the Flow Variable (you can use other things too, or you can just skip this part):

You then create the folder using the new “target_folder” variable

You now create another Path variable with your new Excel file name (again from “Sheet”). You give this one the extension “xlsx”.

The “Value” comes (again) from the “Sheet” Flow Variable:

And finally you write the new files in their sub-folders. In the Loop End node you can see how this all played out:

You can modify the elements and make other combinations.

Excel - Loop over Sheets and turn into individual Files - KNIME Forum (78171)...

[lazaronewhall17]

mlauber71,

Thanks so much for the detailed explanation. Was able to run the process perfectly. Very appreciated.

Laz