Excel file is stored in shared location(NAS Folder), even if the excel is open in another system, while reading and updating excel it should not throw an error.
Please let us know how to build.
To read, we can copy and read the excel but for update the excel how can we proceed
When an Excel file is stored on a shared NAS folder, it can be locked if someone else has it open. Then we will get errors when reading or writing the file.
The simple and safe solution is to work on a copy. First, copy the Excel file from the NAS to your local. Read and update this local file so you do not face any lock issues. After all updates are done, try to copy the updated file back to the NAS and overwrite.
Use a Try-Catch or Retry Scope so the robot waits and retries if the file is still open by another person. This method can avoids errors.
We cannot update the excel if someone is already opened by another user.
Step 1: Copy the file to working folder.
Step 2: Update file in Working folder.
Step 3: Replace a file in original folder& empty the Working folder
Step 4: If any issues in replacing send an exception mail to user to close the file, Copy file it to Exception folder.
Try to use Workbook activities (not Excel Application Scope) since they don’t lock the file, then update by writing back the modified DataTable with Write Range.
Or save a copy and modify then overwrite to that excel file.
If helpful, mark as solution. Happy automation with UiPath