Hi,
In our application we have to export 3 million records and excel can handle only 1 million data per sheet, so we are creating multiple excel for 3 million records using multithreading and, in the end, we are combining these excels into single excel file using "WorkBook_AddSheet" but after adding 2-3 sheet (50mb per) we are getting below error message.
We also tired with timer but still getting same error, so is there is file size limit?
Hi Amit
That stack trace seems to point to a connection issue with the API where you are sourcing the data from and not an issue with the Advanced Excel component.
For the API you are connecting to I'd suggest implementing paging when you are trying to get the records.
Hope that helps.
Hanno