I’m facing some strange issue with Excel Read Range activity.
I’m trying to read all sheets in one workbook. I’ve trying it by using read range activity sheet per sheet (some workbook files has more than 5 sheets then I’ve to get it more than once time), ok, of course there are another better ways to perform it, anyway, ok it’s working…
However, I dont know why, but in some cases the read range activity become big slowly (about 3 or 4 minutes to read all sheets) and another just 20 seconds… We tried to test with a lot of excel files and the same issue…
Excel App Scope -> Read range activity (sheet contains different kinds of data type, number, date, string and others…) -> Get it all in DataTable. Sometimes fast (20 seconds), sometimes slowly (3 minutes). The files are almost the same, but not equal in terms of datatype/number of sheets. Is possible to exists something wrong with datatype reading? (I mean from Uipath activity processing side)
It turns out to be funniest, because it was working correctly / faster 1 month ago, and we have not updating anything in the code. I don’t know if Uipath update something with that activity but still don’t find a workaround for my situation.
Did u already experienced the same issue? If yep, please share!!!
Thank you in advance