Color an Excel Table

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