Colouring and formatting an Excel Table

Is there anyway to colour or format a table to be exported to Excel in Knime?

I’ve had a look at the “color management” nodes, but I think that is just for when you view it in Knime and not for when you export a table to Excel.

Any advice would be great.

Hi Earl,

If you download the Erlwood nodes from the Community Contributions then you should have an XLS Coloured Writer node that:

“Writes an XLS file. You can customise the background colour of the cells in the XLS file by using the colour tab in the node configuration. For dialog and ports description, see “XLS Writer” node.”

Does this help?


1 Like

Do you know where I can download Erlwood nodes from? I’ll let you know if it does the trick.

You could use Python and openpyxl but maybe that is a bit of an overkill … but the necessary functions should be there

Still I point you to two examples

1 Like

Thank you for the examples :wink:
I wasn’t able to access the first link from my works computer, but I could download both of the files.

I get the flowing error when I try to run it:

Execute failed: Could not start Python kernel. Error during Python installation test: Could not find python executable at the given location: python3… See log for details.

I might have to install python again.

Hi @Earl983nfn,

the Erlwood nodes can be found in the Community Extensions. You need to have the proper update site enabled in the KNIME preferences. See here for more details.


Yes you would have to set up Python and connect it to KNIME. Although I did not use a special environment with 3.5 but just the standard Anaconda. Yet I only use the official “conda update anaconda” command to update the environment in order to keep the version of the packages in sync (let Anaconda do that).

And you would have to install openpyxl package