Multiple robots accessing one excel file

Help Orchestrator
,
1

this is an interview question. plz respond… i have a multiple robots … so those robots have to one excel file. that excel is put one share loaction .so all the robots have acess to excel …how can we implement this… plz explain

2

@katta_nikhil

  1. If you are only reading data then you can use the excel in read only mode and there would not be any issues
  2. 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

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.