I have a shared excel file in onedrive that is being read and written by multiple robots. However, I came across this problem where the OneDrive could not update or merge the update of the same file. At this point, UiRobot has treated this transaction as successful thus it will move on to the next transaction, causing this data to be lost in the shared excel file.
Subsequent updating of the excel file will cause an error both in the robot as well as the OneDrive. Robot’s error will be unable to read range because in the excel application itself, there is a file recovery prompt. OneDrive’s error would be that it is unable to merge the changes and would require user intervention to choose which data to keep or merge.
Any help is appreciated on how I can prevent such error or to at least detect that the file has finished syncing? The thing is if multiple robots were to update the file at the same time, the frequency of the status “Syncing” will be higher.
Hope that we can find a solution for this. Thank you!