How to read or update data for one common Excel file with multiple bots in production

Help Studio
, ,
1

Hi Team, Good morning.

Can anyone help me with, How to read or update data for one common Excel file if multiple bots accessing/reporting to that excel in production. The complexity in this scenario is when the excel file is using one bot, It will be in read only mode or error with “The file is using by Another User” for next bot to access.

2

You can keep those files in one common drive. U can read the file the same folder should be accessible by all BOTS

3

Hi @Shankar_MasRobo

Are you accessing the Excel file through different processes with multiple bots, or through a single process with multiple bots?

4

Hi,
A single process with multiple bots.

5

Got it… @Shankar_MasRobo

As of my knowledge, it is not possible for multiple bots to read from or update a single Excel file simultaneously.

Instead of this you can a small logic for it. That was Lock and Unlock file. I have made a workflow for that logic, check the below workflow,
BlankProcess.zip (8.0 KB)

Hope it helps!!