If more than one bot accessing one file how to avoid data redundancy or bot failure

Help Activities
, ,
1

Hi,
For example I have one excel file in which I want to update something using 5 different bots so how to update the data using 5 bots without any error at run time.

There is a chance to get exception if one bot is accessing and same time second bot will try to access the file.

Thanks,
A.Nadeem

2

@akhtar.nadeem

You have to use a kind of locking system…enclose the excel scope inside try catch and the try catch inside a while loop…

Now if excel fails with already being used then catch and wait for some time and retry…(makesure to give random delay

Cheers