XLS Formatter - Format a column title under conditions

Community Extensions
1

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

2

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
Marvin

3

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