Here I encounter an issue while I’m trying to use read range for an excel sheet that created by Robot in previous steps, it contains around 31k records which columns from A-BE. It was created using Write Range as mentions, so that means our datatable will be able to contain so many records.
But here is my test results:
A1:BE31000, Error
A1: BE5343, Error
A1: BE5342, OK
A1: O5343, Error
A1: N5343, OK
A1: N31000, OK
To Ensure this is not an issue with data in the excel, I replaced all the data from 5343 with row 5342. the result is same.
In your screenshot of the error, can you get another screenshot of the same error, but make sure you expand the details part of it. That contains more info about the error. That would be really helpful in identifying the problem
Hi
Welcome to uipath
Make sure that Read Range is kept inside EXCEL APPLICATION SCOPE activity
That is if we have the excel application installed we can and it is reliable to use excel application scope activity which can include Read Range activity rather using workbook activities
From exc related READ RANGE activity we can read it
Kindly try this and let know for any queries
Or if you are already using excel application scope activity then we need to check with the exception message for the reason but this can be resolved
here I copied the details of the error as below:
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)
Thanks for the advice Palan. If you read clearly about my post, I stated that it works within the range A1:BE5342, and all the ranges from AtoN. I did use read range during the application scope
Could you please tell me, What kind of cell format issue did you find in your workflow?
Because i am having the same problem as yours but not able to figure it out why?
Sry for didn’t reply for quite some time. this is due to excel sometime will try to convert a number e.g. 20190019020 to date format, and if failed it will display as xxxxxxxxx(infinited long), and read range will encounter error when read this. After that I changed whole excel format to text the issue was resolved
Hi,
I have faced the same issue while reading an excel where there is a column with date in custom format(“dd-MMM-yy”) but on clicking that cell, the date format will be (“dd/mm/yy”).
solution for this issue is, changing the date column from custom to text.
But,
Is there any way to find out in which cell or column or row the format mismatch is there.
i mean i just need to get a message box ,stating the column ID of the cell with the mismatch.
kardelencihangir
ashokkarale
Anil_G
sudster
burcin_memoglu
tolga.kamci
Binit_Sarkar
shubham.jadhav
Achiranga
JK_MECH