We have BOT which reads/writes into an excel File. We are running 2 instances of this BOT. So 2 instances are reading/writing to same file.
For reading - we are using application scope in read-only mode, not visible mode. After reading close workbook outside application scope.
Before writing we are checking file is available for Writing with C# code.
For writing - we are using application scope, not visible and save workbook activity after writing. And close workbook outside application scope
If fails BOT will retry couple of times. But problem is occasionally we are getting an error message called “.xlsx is currently in use. Try again later” (Attached screenshot) . When BOT throws this error, BOT execution will get stuck there. Please suggest. Let me know if you need more details.