while reading excel data more than 1048576 rows facing issue - how to fix this issue in UiPath? any suggestions would be helpful
Manually are you able to?
ideally its an excel limitation too
did you try with workbook activities?
cheers
1 Like
yes while trying with read range workbook activity i got the error? so any other way to read excel file quickly?
Try using excel as DB..but ideally its advised not to use such huge excels
for connection try check here - Excel connection strings - ConnectionStrings.com
https://medium.com/globant/using-excel-as-a-database-in-uipath-e5206120d4a5
cheers
1 Like
Any sample code or activities to be used for this, thanks
1 Like
1 Like
sure thanks for the help, will check and update you
1 Like
There can’t be rows more than 1048576 in a single worksheet so not sure what error you are facing.
Please share the error screenshot and more details.
while executing the run query, im getting this error - Run query: ERROR [HY000] [Microsoft][ODBC Excel Driver] Unexpected error from external database driver (1).
You are using the Workbook activity. Try using Excel process scope → Read Range activity.
yes it is also taking some time for using the excel read range activity as well
1 Like
it is taking 6 mins to read it.
Yes, it will be slower but reliable than the Workbook activities.
Either usesome code to convert the sheet to a csv. the do a read CSV
OR
Are you using Find Last Row Excel activity then use the output to define your range
“A1:D”+LastRowIndex.Tostring
Read Range has always been super slow
1 Like
I won’t recommend using excel activities to read a huge excel having million rows. Try converting it to csv or you can read it through a C# code using OleDb streaming
1 Like
ok sure will try it and let you know
ok sure will try it and let you know on the same
okay thanks for now ill manage it, in future ill find a way to try other methods.
2 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.