Well yes that is possible. You could use the mighty Python library OpenPyXL . Yes it is some work but it is doable (you have a few links to examples attached).
Then there are the Continental Nodes for KNIME that deal mainly with formatting. They might be useful and possibly easier to handle than Python.
Python Excel Drop Down
I attached a workflow that uses your example to create an Excel file via Python. And also one from the example from before. I think you have to provide the Python Script with a valid path (in this case I used the path of the workflow) and you have to close the file at the end.
[image]
kn_example_python_excel_drop_down.knwf (21.4 KB)
Python Excel manipulation
You can do several manipulations for Excel with the Python library openpyxl . Please keep in mind that the syntax is not super easy and I encountered some quirks (they may or may not have to do with doing it on a Mac)
[image]
kn_example_python_excel_manipulate.knar (57.1 KB)
Also the concept of Continental to spread the use of KNIME within the company is bearing some fruit, although I have not (yet) seen Excel Data manipulation nodes, but you already can do a lot of things with their nodes.
…
well … there is a way. You could use the Python module openpyxl and open the stored excel file in Python and do some manipulations and then save it again. Openpyxl offers a wide range of possibilities.
Please be aware that this might not be the most stable way, and it could get tricky if you have large or complicated Excel files.
[image]
[image]
kn_example_python_excel_manipulate.knar (54.5 KB)
Python Excel table object
OK I think now I get what you want. Yes it is possible to first save a table as a ‘pure’ excel file and then define a range as a table object “All” which you can later use to refer to it.
In my example the no of lines that the object would have is assigned dynamically while the columns are fixed but one might also be able to change that to a dynamic setting.
[image]
After the ‘raw’ KNIME export:
[image]
After openpyxl got to work:
[image]
(cf. https://openpyxl.readthedocs.io/en/stable/…
3 Likes