Excel sharing with multiple bots

Learn Academy Feedback
, ,
1

Hello,

Currently I am using Share drive to keep test data and Result file. But I am getting excel lock error when 2 bots are trying to update same excel sheet.

Whats best way to handle this issue?

Currently i am keeping excel in Shared mode to fix this problem, any other optimized solution?

2

If u r using parallel or multiple robots, then add the file reference to queue first. Then get transaction items .

3

But how that’s gonna solve parallel write problem ?

4

Its better to Copy a Local Reference and then move to the Sharepath.