[ExcelExpression] Hi Guys, I just want to ask if you have other ways on applying the expression on excel through Knime? I know we can already use the Math formula node or Column expression Node for this but our client wants to see the expression used in calculating the data. Here`s my way of doing this, I used String replacer node to write the formula in the cells but I think this is not a practical solution because I need to do the expression repeatedly for every cell. I can use some tricks here but its not practical. If you have any solutions, suggestions or ideas, it will be a great help :blush: Thanks in advance:blush: Regards, Gambit

How to apply excel expression on excel through Knime?

mlauber71 November 11, 2019, 9:19pm 2

It is possible to manipulate Excel files in KNIME with the help of the Python package openpyxl like in this example:

1 Like