Same excel file use by multiple bot

[Aleem_Khan (Aleem Anwer)]

Can you please anyone help me how to make a process if i have one single excel file and there is multiple row aprx 3000 and I use multiple bot to run that process and all bot use same excel file how can i achieve that.

[lakshman (Ganta lakshman)]

@Aleem_Khan

Convert that excel file into db file. And then multiple Bots can work on the same file.

[TimK (Tim Kok)]

Do you want them working on it at the same time or can they wait for it to be available?

Take a look at this post to see if it could help you?

Multiple robots updating the same shared excel file

Hello, I have a shared excel file in onedrive that is being read and written by multiple robots. However, I came across this problem where the OneDrive could not update or merge the update of the same file. At this point, UiRobot has treated this transaction as successful thus it will move on to the next transaction, causing this data to be lost in the shared excel file. Subsequent updating of the excel file will cause an error both in the robot as well as the OneDrive. Robot’s error will be u…

Another option is to split the file into sub-files first then recombine them after processing in order to prevent contention etc.

[ushu (Usha kiranmai)]

@Aleem_Khan Try below tips

• You can use CSV file instead of excel so that the multiple bots can access the file at the same time
• Use try catch while reading the excel file. If an exception occurs then wait for few seconds and retry again