How to read large excel file with an around 1300000 rows

[atugupta5]

Hi Team,

I have few excel files, In combination, all the files’ total rows will be 1300000. Is there any way to read this in UiPath without any exception or memory issue?

Thanks

[Manish540 (Manish Shettigar)]

@atugupta5 Check this below link,

How to read huge excel in Uipath

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 …

Hope this may help you