XLS Formatter - Format a column title under conditions

Hi all,

I have a table with two columns with the title A and B.

In each column I have integer values.
Now I want to apply following rule: If the sum of column A is greater than 0, the color of the column title should be yellow after the export. The same for column B.

I know there are XLS-Formatter but it was quet hard for me to apply the rule…can I do it in KNIME?

Kind regards. T2H

Hi @Time2Hire

I don’t have an elegant solution available, but maybe this works for you?
20608.knwf (28.4 KB)

The key idea is to map the sum to a color string (e.g. “#FFFF00”) depending on its value. Formatting is applied using the XLS-Formatter nodes you mentioned.

Kind regards


Wow, that was really helpful! And it works!! Thank you so much!!


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.