Insert Data of Knime in prepared Excel table

[TheScientist]

Hi,
I’m new.
With KNIME I scripted something that reduce my amount of data of a big input. The rest of this should be in a prepared excel table. Is it possible program that the data will be copied and paste it in the prepared table?
The table has already a sheet where the data going to be evaluated with many commands.

All the best
TheScientist

[TheScientist]

or is it possible to read the excel file with the command in the main and in the auxiliary sheet?

[izaychik63]

U can use Sheet Uppender https://nodepit.com/node/org.knime.ext.poi2.node.write2.XLSAppenderNodeFactory
to populate data and reference it from table sheet.

[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