Write Huge data from Datatable to Excel File

[avinashy (Avinash)]

Description

Hi There,
I have a huge data around 7 lakhs in the data table and i want to write into an excel file.
I am using excel process and write range, however getting the following error - Write DataTable to Excel: Exception from HRESULT: 0x800A03EC.
Can you please suggest how to proceed further to get this resolved.

Thanks

Link

https://cloud.uipath.com

Date

2024-12-06

Related UiPath products

Studio

[Anil_G (Anil Gorthi)]

@avinashy

try writing in chunks inside a loop

or try with excel workbook activiites

dt.AsEnumerable.chunks(100000) will give you 1 lakh rows each time and in loop you can write and append to excel

cheers

[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