Read Excel will create a datatable and add the data from the file to the datatable.
So if you create a datatable with the same variable, your read excel has no function?
You also try to add only one column with the name from row(0) and then add one entry with the same value… that is not two columns as in your first screenshot… again, if the read excel is reading the file you want to write to, then do not create a new data table, add to the table you get from read excel.
You are using row, so I suspect you are inside some kind of loop. It will be very inefficient to keep writing to the same file at every loop; you should read the existing file outside the loop, add rows inside the loop, and then write the result after the loop. If you are worried about errors during the loop, you can wrap the loop in a try catch activity.
You can see examples on how to work with datatables here
But for this ideia I think I need to create a filter every time I run the workflow to not get the row with the word Yes at column R and just get the empty R row
The second ideia is to create a new excel file and use as a log. After that I will delete the rows that finished combine with other automation.
What solution do you think is best for me to ensure that my automation has gone through all the lines and if it got stuck, to know which line it got stuck on?
Sounds like you did the right thing then ( saving for each row )
The easiest, would be to add a column, and then use a filter. It’s been a while since i last tried it, but i believe you need to create a tableview to make that work. So read before loop, add column of missing, create filter and loop over the filter, (these is a property for views on foreach data row ), then update the row and save at the end