Is it possible to keep all the other sheets in an excel file?

KNIME Analytics Platform
1

Hi everyone!

I am working on automating a report I have on an excel file. I have a database sheet, while other sheets contain pivot tables or dashboards that gather data from the database.

On Knime I am working only on the database sheet, but when I export the final file with the Excel Writer node I lose all the other sheets.

Is there a way to keep them? Am I missing some kind of setting that allows me not to lose the other sheets?

Thank you in advance for your help!

1 Like
2

@Giacomo_Di_Ruvo welcome to the KNIME forum. For the Excel file you select append and for the sheet overwrite (or append) then the rest of the excel fill should stay the same.

2 Likes