I need/create an table fomated Excel file. I used the “Excel Table Writer” Node, to formate it, but… This Node destroys the [xl/worksheet/sheet.] xml header. When i rename the file to .zip and open the xml, the first line is missing <?xml version="1.0" encoding="UTF-8" standalone="yes"?> Why? Exists an other work around or solution? Best reguards

Do you want to populate an excel with pre-existing formatting? There is this handy node: [image] Write To Excel Template This node writes the input data table into an existing Excel file without changing its formatting. Alternatively a new file will be created based on the templa…

Hi @sven7904 - Are you referring to this component created by @tommy ? [image] Excel Table Writer – tommy Write the data table to an Excel file and format that table as a *Table*. This includes filter functionality out of the box e.g. Opening the excel file and "Se… If so we would need to get his input. Maybe there are adjustments to be made to the Python script inside the component to alleviate the problem?

@sven7904 you could try this approach to format a “real” table in Excel if this is what you want: [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/…

Hi nick_the_best, thats a good solution. it works for me. Thanx

Hi ScottF, yes… But i´ve test the solution from nick_the_best with the writer to excel template. That works fin efor me.

You’re welcome! It’s a great node. A little clumsy, but very helpful.

Problem: Excel Table Writer

KNIME Extensions

mlauber71 August 1, 2025, 2:46am 3

@sven7904 you could try this approach to format a “real” table in Excel if this is what you want: