Insert only some data in row of Excel File


#1

Hello,
I have created a Datatable in an Excel File.
The table in Excel is partially completed.


I need to insert the remaining data in the Excel file.
I tried in this way:

but it gives me an error: for each row in Tabella_Excel_Trovate : Collection was modified; enumeration operation might not execute.
How can I overpass this problem and insert the remaining data in the Excel?
Thank you so much friends,
Camilla :slight_smile:


#2

@CamiCat create datatable with those 4 columns, write to excel with starting range as D2. It will work


#3

you Can assign variables like row(column number)= value or row(“firma”) =value in the for each