Hello, everyone
Both Read range activities throw the exception, when i try to read all from some special workbook.
I know that the reason of error is exactly in the worksheet because for others it works well. Did somebody meet such case and anybody knows how to resolve it?
RemoteException wrapping UiPath.Excel.ExcelException: Выход за пределы диапазона. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW)) ---> RemoteException wrapping System.Runtime.InteropServices.COMException: Выход за пределы диапазона. (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.WorkbookApplication.ExtractRangeTo2DArray(Range range,
Boolean preserveFormat)
at UiPath.Excel.WorkbookApplication.ReadRange(String range,
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)
Translation: “Выход за пределы диапазона” = “Out of Range”
Thanks.