How to read huge excel in Uipath

Help
, ,
10

Fine
I would go @Shubham_Varshney
Like we can split the data and read them
The sequence of activities will be like
— use a Build datatable activity and create a same structure datatable as in excel with same column name and order of columns
and get the output as Finaldt
And followed by this use CLEAR DATATABLE ACTIVITY and mention the input as Finaldt

—the inside excel application scope use Read range activity we can set the range like this
“A1:G1000000”
Which will give us first set of datatable and name it as dt1 and here in the property panel enable add headers

—then use again a READ RANGE activity and disable the add headers property and mention the range like this
“A1000001” so that it will start from were we left
Where get the output as datatable named dt2

—now use a For each row loop and pass dt2 as input
And inside the loop use Add Datarow activity and mention the ArrayRow as row.ItemArray and datatable as final dt
So all the records from dt2 will now be added to Finaldt

—then finally use MERGE DATATABLE activity where mention the source as dt and destination as Finaldt

So Finaldt will be our datatable with all records from excel
Though it takes the same time or even less than normal excel application scope and read range activity, it will work without any fail or error

Hope this would help you
Cheers @Priyambada_Panda

7 Likes