I am running a process in which the robot must write few times line by line. The problem comes that excel always asks me to replace the file, when robot should just write inside it. When the message appears robot does not nothing so the process stays stopped. Do you know how can i do it?
I am using system excel activity, and not application scope.
Use Append Range activity of workbook
Try using data table activities and add the rows with “Add Data Row” and finally use write range to write the data table… in this way you can reduce opening excel many times(Which may sometimes crash)
For your scenario use add data row convert excel into datatable
Thanks for your comments!! I changed to Application Excel and it works!