How to manipualte certain ExcelSheets but keep the others?

Hey folks!

I have an excel file with 4 existing sheets as a template. With my KNIME workflow I want to fill data in 2 of those 4 sheets.
For that I am using the excel wirter and excel appender node.

The problem: After my worklow successfully wrote the data into those 2 sheets, the other 2 disappeared.

Is there any way to maintain the sheets that I’m not actually writing on?

Best regards!

Hi there @EngiP3,

why using Excel Writer on existent file? Use only Excel Appender and other Sheets should stay intact.

Br,
Ivan

2 Likes

Well… You are right :smiley: I started with an Excel writer for testing because I received the one with the 4 exsting sheets later!

Thank you!

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.