Insert Data of Knime in prepared Excel table

[stelfrich]

Hi @TheScientist,

@izaychik63

U can use Sheet Uppender

This post in another topic contains a possibly interesting example for your case:

Appending a template to many excel files

Hi @Groumayo, To achieve this, you first have to create a template with a dynamic named range for the input data that you use to generate the plots in the Graph results sheet. Follow Method 1 of https://support.microsoft.com/en-us/help/183446/how-to-use-defined-names-to-automatically-update-a-chart-range-in-exce to achieve that. You can also take a look at my template: template.xlsx (14.4 KB) The trick in the workflow then is to create a copy of the template in a temporary directory and use an…

This shows how to replace a data sheet in an Excel workbook while another sheet uses data from the data sheet to create charts.

Best,
Stefan