Write Huge data from Datatable to Excel File

[AJ_Ask]

Hi @avinashy

You can follow this method

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 helps