I need Idea/ Practise to followed to sort out the below requirement,
I have an Excel Sheet in a Path which contains list of Names to be assigned in a process, So after assigning a name from excel to a transaction of the process we should update the count for that particular name.
I have around 5 Robot’s deployed to do the assigning process and all the 5 bots should update the same sheet, So we have a probability of more than one bot accessing the excel sheet at same time. If we keep the excel sheet as shared file, there is a chance of more than one robot editing same cell.
It will be great, If i can get a suggestion or idea to sort out the process.