XLS Coloured Writer wishlist

[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)