Excel Writing Functions - Dynamic files export

Dear all,

can you help me to write an Excel Output with result saved as functions.

e. g. Result of a sum would be SUM(…) and so on?

KNIME do Things really efficiently but I Need as an Output a file with functions so that the user can just modify some column and the result will change also.

Yes it is possible to write functions to an Excel sheet with Python’s OpenPyXL and KNIME:

image

For further inspirations about KNIME and Python and Excel you might read this discussion.

kn_example_python_excel_enter_formula.knwf (23.2 KB)

4 Likes

@mlauber71 do you mind providing the rest of this workflow? I’m interested in seeing how all the nodes are configured.

Yes of course. I had it prepared as usual but forgot to upload it. Have attached it now to the original post.

1 Like

Thank you!

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.