Read Range : Out Of Present Range. (Exception from HRESULT: 0x8002000A(DISP_E_OVERFLOW))

News Knowledge Base
1

When reading data from Excel sheet using Excel Read Range activity, error "Read Range : Out of present range. (Exception from HRESULT: 0x8002000A(DISP_E_OVERFLOW)) " is thrown.

Root Cause: Note this error generally occurs when there is value in excel cell which is not relative to the defined format of the cell.

For example “1111111111” value is given in cell whose format is “Date” . This cell value will look like below:“#################” as value is out off the range of the cell format.


Resolution: This kind of values of values does mean anything and UiPath studio will throw exception (HRESULT: 0x8002000A(DISP_E_OVERFLOW)), when reading the cell value.

In order to resolve this ,below approaches can be followed:

  1. Change the format of that cell to "General"
  2. Correct the cell value and provide the valid value which is with in the range of the cell format
  3. Remove the cell value ,if it is not required.

After making changes as per above approaches, try to read value using Excel Read range activity.

Also , refer to the UiPath Forum post Read Range Inside-Application-Scope-With-Using-Filters-Fails .
1 Like
2

Thank you so much, this solution worked perfectly for me. Although it was a bit of search to find which column could have had the unknown value.

But glad you posted this