Excel Formating

[helpmeplease]

Greetings!

I’m having a problem with the way my xlsx. files are being exported.

I came across Continential Nodes for KNIME, but I can’t really find any YT tutorials to grasp the idea of how to implement it into my workflows. Has anyone maybe come across any?

I foremost need to learn, how to:

1. Freeze the 1st row when I export my xlsx.
2. Bolt the 1st row when exporting
3. Assign in advance the cell/number/text width/height
4. Assign colors in advance

Simply put, I’d like to automate these last steps of creating a basic statistical report on some data - the aesthetic part.

I tried playing a bit with Continential Nodes, but I think I lack quite some knowledge to learn it on my own. I found some descriptions of what different nodes do, but that wasn’t enough.

Is that to complex to learn and I’m one step ahead of myself? Cheers in advance!

[mlauber71]

@helpmeplease welcome to the KNIME forum. I am not sure there is a consistent introduction about the Continental nodes. I have not done much with them but it seems you have to grasp the concept of this “control table” it seems.

Continental Nodes for KNIME — XLS Formatter Nodes | KNIME

Then there is the free book “From Excel to KNIME” which also has a chapter about Continental nodes. This also might be a good pint to start understanding the concept.

From Excel to KNIME | KNIME

the book is also available in other languages like German, Spanish and Portuguese:

KNIME Press Overview | KNIME

Another overview about what is possible:

02_Pretty_Table – Continental_KNIME_Extension_Developer

Then there is this collection of tutorials:

knime/Examples – 01_Tutorials

And there is an older FAQ

Continental Nodes for KNIME FAQ | KNIME

[helpmeplease]

@mlauber71 thank you very much for a fast and informative response!

I appreciate the help!

[takbb]

Anybody arriving here in search of example workflows of using the Continental nodes for formatting Excel files, may be interested in this excellent demonstration workflow by @TosinLitics.

This should really help reinforce understanding from the above tutorial/documentation links and is a great “one stop shop” for show-casing the variety of formatting options available.

Continental Nodes Example – tosinlitics