Color an Excel Table

[razvancomanici]

Hello!

Very little time I use the web server.

My problem is that I have to send information to some people in Excel. But before that I want to color the table head.

How do I do that?

Thanks!
Razvan

[mlauber71]

You could use Python to do that. Or you could reference the data in excel from a separate sheet while the formatted one stays the same

Python Excel manipulation

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)

Python Excel Drop Down

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)

[razvancomanici]

Thank for the information!

[matthias.albus]

There is also a perhaps more out “of the box” solution; install the erlwood extensions (part of the community contributions of knime). They offer a “coloured xls writer node”.

best

Matthias

[agaunt]

Hi @razvancomanici, you could also try the BIRT Report. Just connect the table you want to write to Excel to a Data to Report node and click the Report button (https://docs.knime.com/latest/report_designer_user_guide/img/02_report_icon.png). Then you drag and drop the data set from the Data set view to the layout window and color the header. Finally you click Run -> View Report -> As XLSX and you’re done. Nice add on: Even zebra-styled tables are possible. Therefore you click on the table in the Layout window, click the button with the orange lines on it, click on the “Highlights” tab on the bottom and add the condition “row.__rownum%2 Equal to 0”. Then you can choose a different background color for every second row.