Write into excel fastest way

Question

Hi,I'm trying to write huge data from DB into excel about (800,000 rows and about 48 columns),what is the best way to do that?

Ramya Sivakumar · Answer

Hi Bashar,Greetings from Syncfusion.We suggest
you import the data from the database using the data table. ImportDataTable method in XlsIO which has the ImportOnSave argument allows you to import data
with less memory consumption along with improved method performance by
serializing the data directly on the save method. This option is preferred for larger data
that need to be imported in a short time.Kindly refer to the following link to know about Importing
data into Excel in the best way.https://help.syncfusion.com/file-formats/xlsio/improving-performance#importing-datatableRegards,Ramya.

Bashar Al haj hamad · Answer

Hi,I tried it and I'm getting this exception:System.OverflowException: Not a legal OleAut date.How I can solve it?

Ramya Sivakumar · Answer

Hi Bashar,Please share an issue reproducing sample or stack trace of
the exception which would help us to proceed further.Regards,Ramya.