Problem: Excel Table Writer

[sven7904]

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

[ScottF]

Hi @sven7904 -

Are you referring to this component created by @tommy?

Excel Table Writer – tommy

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?

[mlauber71]

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

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

[Nick_Reader]

Do you want to populate an excel with pre-existing formatting? There is this handy node:

Write To Excel Template

[sven7904]

Hi nick_the_best,

thats a good solution. it works for me. Thanx

[sven7904]

Hi ScottF,

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

[Nick_Reader]

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