Manipulating excel Sheets

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

Python Excel manipulation

Python Excel table object

3 Likes