- If you are only reading data then you can use the excel in read only mode and there would not be any issues
- If you need to update data…then use lind of a locking mechanism that is if one bot is using the excel then all other bots would get file already being used …so wait for few seconds and try again…for this you can implement a loop and if fails wait and continue the loop again…if excel retrieved then end the loop and udpate
We can have a proactive approach as well by adding asset and getting the lock for one machines for this use asset…check the asst value using get asset if it is na then use set asset and set environment.username to asset and then get asset again and check if the value is same as environment.username if its same lock is acquired and you can use excel…else wait for some time and try to acquire the lock again
Hope this helps
Cheers