Sheet names based on input file's names

[zoltanboros6]

Hi all!

I would like if the output xls file’s sheet names can be based on the input table’s file names.

How can I do this?

Thank You,
Z

[mlauber71]

@zoltanboros6 welcome to the KNIME forum. You can take a look at these examples:

Create individual excel files from multiple worksheets

@lazaronewhall17 yes this can be done. With such tasks you can combine several nodes into a system to handle your files. [image] 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: [image] 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): [image] You then c…

Import EXCEL - a meta workflow trying to answer questions about importing...

KNIME and Excel — An Overview of What You Can Do