2 bots running at same time using excel in unattended mode? if one bot is using excel then there will be error for other bot. How you will overcome this issue?
If bots are only reading the data, Configure Excel process scope to Read Only mode.
If bot’s are reading and writing the file, add Retry Scope to retry file writing in case other bot updating the file.
Thanks,
Ashok 
Here we need to use Boolean
->Use an flowchart available in the activities panel and in that place that try catch and in the try please give the excel activities or workbook activities which are being used.
->In the catch block use the assign activity and assign a boolean variable as False.
->After the try catch use the flow decision and use the boolean variable within that and if the boolean is false then drag the flow back to try catch and if the boolean is true then just end the process over there and place the remaining activities outside the flowchart.
For better understanding please check the below images:
Regards
1 Like
-Use Read-Only Mode for Reading Data
-Create a Copy of the File
-Use Database Instead of Excel
-Implement File Locking Mechanism
Thank you this is the answer im looking for
can you explain this briefly. Like how one bot can read excel file & other bot checks the boolean statement, based on statement the second bot executes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.