Append data at the bottom (last row) of a excel file

[IvaR]

Hi,

I need to feed a document with new data, so what I was doing was running the workflow, writing the file and opening it after execution, and then copying the rows and pasting it into an existing file. So this is my Q: Is there a way to append new data to an existing excel file?

Thanks in advance

[tommy]

hi @IvaR

there should be a simple solution for your problem…
Beside calculating the “new data” you may read the existing Excel file with the help of the Excel File Reader node.
Then you may Concatenate the existing content with the new data with the help of the Concatenate node
At the end you save the new table with old and new data as a xls file. You may even overwrite the existing one.

Hope this helps, Greetz, Tommy

[ipazin]

Hello @IvaR,

this is not possible with native KNIME nodes but you can use Python (see here: Adding to an existing Excel File) for example or read data into KNIME as @tommy suggested.

Additionally there is ticket to handle it and have given it +1. (Internal reference: AP-14911)

Br,
Ivan

[IvaR]

Thank you!!!

[IvaR]

Thank you!!!

[pawanmtm]

this seems to be one of the much demanding feature people are looking for including me…

Regards,
Pavan