Write to Excel Template

[sanchezwalter]

Hi Everyone,

I am currently taking advantage of the Write to Excel Template Node to place data and maintain formatting, specifically for drop down functionality. The issue is that my excel spreadsheet template has multiple sheets.

I have tried to loop the data by sheet, but the write to excel template node will always overwrite the file, causing for only the data on the last tab to display. Has anyone ever found a work around so that my final file can have all 3 sheets?

[takbb]

Hi @sanchezwalter , a similar issue came up in the post below from last year. Does the workaround suggested there help in your case?

Write to Excel Template can't select sheets to write

Hi everybody, Currently, I am using Knime version 4.6.0. I have a question that I hope someone can answer. The “Write to Excel Template” node is great for preserving the Excel format, but it is not as effective as expected when it doesn’t allow selecting the sheet to write to. For example, I have an Excel file with multiple sheets, and I want to use the “Write to Excel Template” node to output a new preformatted Excel file with the same number of sheets that were read in. I hope the next versio…

Specifically see this post on that thread…

Write to Excel Template can't select sheets to write

Hi @quangdatitc , I had a little talk with chatGPT which these days is my go-to code writer to produce the base code which I then tweak… Anyway together we’ve come up with the following: You give this component the absolute location string of an existing xlsx file, along with the name of the sheet contained within it that you want to clone. You also supply the location of an output file, and a comma-separated list of sheet names, and it will (in theory!) clone the sheet to the output…

I can’t determine if this will work in your case but take a look and let us know. Also, which version of KNIME are you using? The “workaround” used a piece of java to choir or xls sheets, and the code there is likely to work only with specific versions of KNIME as the supplied libraries change with different releases.