Copy Rows and paste into an existing excel file with existing layout

[mlauber71]

I think basically you have three options.

• Export the data to a separate Excel sheet and use Excel references like lookup to bring the data to your table
• Bring the data together in KNMIE the way you want them and Export them. Downside no Formulas
• Use Python to manipulate an existing Excel File or write formulas to cells

Or a combination

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)