Problem: Excel Table Writer

KNIME Extensions
, ,
1

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

2

Hi @sven7904 -

Are you referring to this component created by @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?

3

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

4

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

5

Hi nick_the_best,

thats a good solution. it works for me. Thanx

6

Hi ScottF,

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

7

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