How add New Columns

[mlauber71]

You could import the data into knime create the new column and export it again.

Or you could manipulate an excel file via Python. It would help if you could tell us more what you want to do.

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)

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)