I’m seeing the error “The process cannot access the file “File name” because it is being used by another process.”
The bot executes the delete activity to delete the excel file that has been created and processed in prior.
I have checked in debug mode, it seems the excel scope activity is closing the excel and there is a kill process “Excel” activity too and delay of 15 seconds before the delete activity, still the above mentioned exception is displayed.
In debug mode What I saw was after excel scope activity closes the excel file, I tried to open it which should open but, here there is an error in excel when opened manually says “Excel cannot open the File because the file name or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file”. Please see the screenshots.
After stopping or bot completes its process steps, the same excel file opens without any popup messages from excel.
What I learn is that UiPath executor during execution of the bot somehow is not releasing the excel file and thus while deleting an excel that had been created using the bot process steps throws the above mentioned error.