I am trying to use the Excel Table Writer node, which I understand requires the openpyxl module. In KNIME, I have confirmed selection of my environment “env”. In Anaconda Shell Prompt, I have confirmed that “openpyxl” is correctly installed in that same environment. Yet, when I run the node, the node errors out and says ModuleNotFoundError: No module named 'openpyxl' I have an excel model that uses INDEX/MATCH & XLOOKUP extensively to reference a sheet that contains the data that KNIME writes into. This data is not fixed and expected to grow. If I don’t use the Excel Table Writer node, I am constrained to using entire A:A column references (as opposed to strictly the range or table object I need). Excel Table Writer node seems like it would be a great solution otherwise.

hi @mlauber71 thanks for providing the hints. I have to admit that I left this component untouched for some time. Now, it has been updated and I have replaced the legacy Python node by a Python script and updated the code. The number of rows and columns is calculated based on the input table, so the whole table get’s converted. In case there are some user requirements to filter some information, the user might use a row/column filter node in advance. What do you mean by “dynamic setting”? My test with the new setup was successful. Hopefully, it’s stable. thanks, tommy

Excel Table Writer Node & Openpyxl

KNIME Extensions

mlauber71 August 30, 2023, 3:14am 6

@qdmt you might have to see how Python is configured in the component. You could also check this example that should just use the bundled version:

2 Likes