XLS Coloured Writer wishlist

[redm]

Not sure if this component is still under active development… but I’d have some wishes.
(Ideally that color feature would be part of the stock Knime XLS writer anyway… Hint )

It would be nice if the writer allowed to:

• only color partial number ranges. Like color red when >= a certain number, and nothing otherwise (no green, no yellow).
• configure the colors used, instead of the hardcoded green/yellow/red/blue (per column)
• also color rows, so I can highlight an entire row based on some condition (e.g. error; that could also allow to apply alternating backgrounds to row to make the result easier to read)

Thanks

Michael

[mlauber71]

If you absolutely must you could use Python (openpyxl) to do a lot of manipulations on your Excel files - which of course is not so KNIME-like.

DataValidation Drop down list in Excel using Python Scrpt node

I attached a workflow that uses your example to create an Excel file via Python. And also one from the example from before. I think you have to provide the Python Script with a valid path (in this case I used the path of the workflow) and you have to close the file at the end. [image] kn_example_python_excel_drop_down.knwf (21.4 KB)

write data to excel sheet on row 10

well … there is a way. You could use the Python module openpyxl and open the stored excel file in Python and do some manipulations and then save it again. Openpyxl offers a wide range of possibilities. Please be aware that this might not be the most stable way, and it could get tricky if you have large or complicated Excel files. [image] [image] kn_example_python_excel_manipulate.knar (54.5 KB)

[redm]

Interesting… I’ll see how big the pain will become, to go that way Thanks for the suggestion!