Overwrite data into existing Excel sheet

I would like to replace old data in existing Excel Spreadsheet by new set of data (I need to update this Excel tab with new data every month). I have the new data ready in a separate new file. Please let me know if is there a way to do it using Continental? or some other nodes in KNIME? Thanks!

1 Like

Hi and welcome to the KNIME forum,

Using this node, you can append a new sheet or replace an existing one.

Best,
Armin

3 Likes

Thank you Armin!

2 Likes

I have found that with large data sets the writing to file tends to be a little slow but your mileage might vary.

2 Likes

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