Excel writer is doing great job in writing data to Excel, either by appending data to end or by selecting sheets to write to. When sharing Excel worksheet with audience it is sometimes required to provide interaction with Pivot Table, or some existing formulas within the workbook, in order to benefit from the KNIME data injection to Excel, we need the ability to name the range of the data, so later use it to refresh Pivot table, or activate formula using this range.

@david_abekasis you could use Python ’s openpyxl package to provide Excel with a named area: [image] Write KNIME table to Excel as table (proposal) KNIME Analytics Platform 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/…

Excel writer with named ranges

KNIME Analytics Platform

mlauber71 December 9, 2021, 4:20pm 2

@david_abekasis you could use Python’s openpyxl package to provide Excel with a named area:

1 Like