Write more excel files which has more sheets

[snalinda]

I need to write more Excel files which has more sheets.

for example
File1.xlsx has 3 data sheets
File2.xlsx has 4 data sheets
File3.xlsx has 3 sheets …etc.

please give me a solution with nested loop handling.

Thanks,
Sanjeewa Nalinda

[takbb]

Hi @snalinda and welcome to the KNIME community.

Perhaps you can supply some sample data to use as an example and provide more context.

What circumstances dictate how many sheets will be written to a specific file for example?

You can write a fixed number of sheets using a single Excel Writer by creating multiple “sheet ports” on the Writer and connecting data to each.

Alternatively in a loop, a single Excel Writer can be called on each iteration and the name of the single sheet name to be appended supplied as a flow variable.
eg

Using a loop to write to the same excel file within different sheets

Hi @JGebhard You are almost there with your workflow but the -Excel Writer- must go inside the loop and this can be done by using the -Variable Loop End- node: [image] In fact the Row Filter won’t be necessary if you are using the -Group Loop Start- node, as this only takes the rows within the group for the current iteration. Choose the correct column for the configuration: [image] Then use the following configuration for the Excel Writer, but alter it to your specific needs: [image] I…

and

Spreadsheets and Loops – knime

The more information you can give, the easier it will be for people to give guidance.