Insert Data of Knime in prepared Excel table

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

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

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.

1 Like

Hi @TheScientist,

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

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

1 Like