How to mitigate risk to write or append record in already opened or locked excel.
Do we have any other options other than try catch block or create duplicate excel file or notify business users to close excel file?
Excel documents which are shared using the legacy share functionality are a nightmare. In the past it has led to things like a duplicate copy of the document being created (Filename(1).xlsx).
It will also prevent you from scaling a process to multiple bots because they will potentially lock each other up.
If you cannot avoid it, consider pushing the write-back to excel into its own process where you can perform the updates either in a single batch where you can do verification that the saved changes were saved.