I am using the Write to Excel Template node to insert data from KNIME into an excel template. This works fine for one sheet, but is there a way to write to multiple sheets inside an excel template? I want to do something similar to the Excel Writer node where you can write to multiple sheets, but within an existing excel template. Is there a node that does this?
I’m currently doing a number of Write to Excel Template nodes to accomplish this, but it’s a bit messy and I don’t know how to control the order in which they run. But my current work around is like this:
Read from Template.xlsx
Output - create new file - Template1.xlsx
Then for the next sheet:
Read from Template1.xlsx
Output - create new file - Template2.xlsx
Read from Template2.xlsx
Output - create new file - Template3.xlsx
And continuing until I’ve added all the sheets I need to the Excel Template. Is there a node which can write multiple sheets to an excel template? Is there a better way to do this than multiple Write to Excel Template nodes, and is there a way to control in which order the nodes execute?