Modern & Classic Excel Activities Read Range Error " The Range Does Not Exist "

News Knowledge Base
, ,
1

Modern & Classic Excel Activities Read Range error fix for "The Range Does Not Exist".

Root Cause

Typically this error occurs when the range is not valid, or when the sheet that is being read is protected.


Resolution

  1. Confirm the range is valid and it does indeed exist.
  2. Try using an Empty String with no Range Specified to Read the entire sheet.
  3. Try reading a small range in the sheet to see if the error still occurs.
  4. Make sure the sheet that is attempted to be read, is not protected. If the sheet is protected/locked, unlock the sheet to resolve the error.
To Unprotect a sheet in Excel:
  • Navigate to the Review tab and then select Unprotect Sheet.

  • Alternatively, right-click on the sheet and select Unprotect Sheet from here.

image.png

If the error is still occurring after the steps above, share the following with UiPath Support:

  • Robot Execution Logs - The Robot logs are located here: %localappdata%/UiPath/Logs
  • Event Viewer Logs - How to get Application Logs from the Event Viewer
  • An example file that the error occurs on
  • The zipped project files for the same version of the project where the error occurred. (Xaml, project.json, etc). Let the Support team know which workflow specifically has the problematic activities.