Dear UiPath Community,
this is my first post and also I’ve already been looking through Forums, but wasn’t able to find a solution. I found quite a few similar cases, but never the solution I was looking for. Thus my question to brainstorm with you guys…
How would you setup a robot with write range in an excel sheet, which will be executed/triggered through Orchestrator every hour, that can potentially be already opened through a User?
Solutions we thought about, but are not really happy with:
- Put the Excel Appl. Scope into a Try Catch (will keep trying until User closes the file…)
- Timeout / Delay and Retry later - maybe 10 minutes (if a user forgets to close a file it will fail for the whole day)
- exit workflow, log the information and write the range elsewhere (conditional) and fix / merge later
- create a copy of the excel sheet and continue there (might need to merge the user input afterwards)
What do you guys think?
Any help and ideas are much appreciated.
Thanks in advanced.