ipazin
September 24, 2020, 9:23am
2
Hello @cmor ,
welcome to KNIME Community!
To my knowledge this is not possible with KNIME native nodes. Probably Python can be used as a workaround. See this topic for example on how to write Table to Excel:
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/…
Br,
1 Like