Write to excel template

[Bewaji2]

Hi forum contributors,

I need your help, regarding a task.
I’m finding it challenging to include the Node “Write To Excel Template” to an existing loops workflow

[HansS]

Hi @Bewaji2

What is the challenge? Include the node somewhere in your wf and see what happens.
But a more structured approach can be, to take a look at KNIME Hub to find links to wf’s that contain the Write To Excel Template. Or see at Nodepit the popular predecessors and successors for this node.
gr. Hans

[Bewaji2]

I have tried the write to excel template node. I was only able to copy only to one excel template. I would like to make use of a loops. That can help copy to over 300 files

[iCFO]

Take a look at this one.

How to use group loop start node along with Excel writer to write files for each group

I have a column which has three unique values A, B, C. I want to write three different excel files in a local folder directory corresponding to each of these groups A, B and C. Is there a way to use the group loop start node and somehow pass variable file name to the excel writer node and create 3 files (in 3 loops). I could not find a way to pass variable file paths to excel writer node. Any help would be deeply appreciated. Thanks.

Essentially you group loop, place excel writer at the end and create variable for file names. In the case of the Write to Template you may need a variable for the template file if they are not all the same template.