Excel always asks me to replace the existing one

Help Activities
, ,
1

Hello all,

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.

Thanks :slight_smile:

2

Use Append Range activity of workbook

3

Hi

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)

2 Likes
4

For your scenario use add data row convert excel into datatable

1 Like
5

Hi all,

Thanks for your comments!! I changed to Application Excel and it works!

Thanks :slight_smile: