Copy Rows and paste into an existing excel file with existing layout

[ipazin]

Hi @MrS,

yep, I understand. What you can try is to have formulas in your formatted sheet to existing sheet where you are going to write data from KNIME. This way once you write data sheet will be filled with new data and you should not lose your formatting.

Regarding VBA Macro check this topic:

Excecute Excel Macro

Hello Is it possible to open a finished Excel file at the end of a KNIME workflow which contains a macro to be executed automatically. It is not about changing anything in the file, the macro should only be executed. Thank you

Br,
Ivan