Excel Pivot Table Tabular layout

[mlauber71]

@psfard you can use openpyxl to define a table area with its Excel functionality

Write KNIME table to Excel as table (proposal)

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/…

KNIME and Python's openpyxl to define and name a Data area in Excel (using...

To create a pivot table with the package is not possible though.

Also:

Read from Excel Table

@Experteece actually you can use Python and openpyxl with KNIME to do that. Identify named tables and import them (cf. this thread). [image] You van extract the tables directly or read all the ranges from your ‘named’ table (areas) and then use KNIME to import them. [image]