Out of present range exception in Read range activity

[Chippy_Kolot (CK)]

I am getting below error in Read range

RemoteException wrapping UiPath.Excel.ExcelException: Could not read range A9. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW))
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32 aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.get_Value(Object RangeValueDataType)
at UiPath.Excel.Helpers.AreaHelper.ExtractRangeTo2DArray[T](Range range, Boolean preserveFormat)
at UiPath.Excel.WorkbookApplication.ReadRange(String address, Boolean preserveFormat, Boolean& isWholeRange)
— End of inner exception stack trace —
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

[Praveen_Mudhiraj]

Check this way

“Could not read range A9,” is typically associated with the Excel activity “Read Range” in UiPath. The error message “Out of present range” is indicating that UiPath is unable to read the specified range because the range address A9 is not valid or is empty in the Excel file.

1.Check Excel File: Ensure that the Excel file you are trying to read from contains data in the specified range A9. If the range is empty or does not exist, you will encounter this error.

2.Verify Worksheet Name: Make sure that the worksheet name is correct. If you are specifying a worksheet name along with the range address, verify that the worksheet name matches the one in the Excel file.

3.Use a Valid Range: Double-check the range address (e.g., A9). Ensure that it is a valid range within the Excel file. You can verify this by opening the Excel file manually.

@Chippy_Kolot

[Palaniyappan (Palaniyappan P)]

Check this knowledge base from UiPath to get this resolved

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

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. Res…

Cheers @Chippy_Kolot

[Chippy_Kolot (CK)]

I have headers at A9.
Scenario 1:
If in Excel sheet I have headers only means it is working.

Scenario 2:
If i have more data (More that 2k rows) i am getting this error.