Excel Writer / Sheet Appender with Excel Formulas

[mlauber71]

In this entry I discussed several possibilities how to bring formulas from knime to excel. Unfortunately they involve using Python. But it is possible.

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