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

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.



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