Hello All, I would like to just input (e.g., read) an xls file, set the background of headers to a given color (e.g., yellow) and output the colored file. I had a look at “Continental Nodes for KNIME — XLS Formatter Nodes” which feels like killing a fly with a sledge-hammer (plus, I confess to beeing too lazy to learn all that for such a simple result). Is there a real simple way to achieve that? Thanks!

Extra simple workflow to color header row backgrounds in Excel file

mlauber71 October 31, 2022, 11:17am 2

@Nazaire well there always is the Python package OpenPyxl where you could do a lot of manipulations, including colouring. This only involves a few lines of code.

4 Likes