Copying cell in output data table to a specific cell in excel file

[mlauber71]

@christarvin unfortunately that will not be possible. The only ‘pure’ KNIME solution would be to import the sheet and (over-)write it back.

Watt you can do ist use Python’s OpenPyxl package to manipulate an individual cell (along with some other interesting manipulations):

Excel Reader dumps formulas

The KNIME import and Export function cannot deal with Excel functions themselves. You can only get the results. If you want to preserve or restore Excel functions you have to either: use them on a sheet you would not touch with KNIME, Formulas that might refer to a ‘simple’ data sheet you would im- and export to and from KNIME use a Python package like openpyxl or R readxl Python Excel manipulation Python Excel table object