Question in excel automation!

Agentic Automation How to Use Agentic Automation
1

Hi all ,

When we are working with multi bot process,
At the end of the transaction each of the bot should update the data in an excel, when we are using multi bot architecture how can we avoid getting the error when all the bots are trying to update the records into a same excel file??

How can we do this??

2

Hi @naveen.s

We have a locking and unlocking mechanism in place. Follow these steps:

  1. Use the File Exists activity to check if the original file exists. Let’s call the output variable OriginalFileExist.
  2. Use a While activity with the condition OriginalFileExist = True.
  3. Inside the loop, add the Rename File activity to change the name of the original file.
  4. Proceed with the necessary operations using Excel or Workbook activities.
  5. Once all Excel-related tasks are completed, rename the file back to its original name using another Rename File activity.
  6. Then change the OriginalFileExist to False.

This approach ensures that the first bot to access the file enters the loop, renames the file, and performs the required operations. If another bot arrives at the same time, it will wait until the first bot restores the original filename. Once the first bot finishes, the next bot can proceed with the same process.

Hope it helps!!

3

For this scenario instead of updating in the all the bot push that value to another queue and make it seperate process to update the status in single bot.

Regards,
Arivu

4

@naveen.s

please check this… I have explained in detail on how to do it

cheers

5

@naveen.s,

I would advise a simple and non complicated approch for this. Just use retry scope activity and add your update data logic inside it.

This will ensure that even if the update operation fails due to another bot using the file, retry machanism will retry updating the data.

You can increase the number of retry if you got lots of bots as per requirement.