Writing large file from IDataReader, out of memory?

[Derrick]

Good Afternoon,

I am working with what looks like version 9.1.0.20, and attempting to write a large data set, via an IDataReader, to an excel file, and run into out of memory errors trying to write the file to disk.

Any suggestions on lowest memory consumption method of writing a large data set to disk thru xlsio?

Thanks in advance,

Derrick

 

[Sridhar]

Hi Derrick,

Thank you for using Syncfusion products.

In Essential XlsIO, we will be using the system memory for content preservation until it is save to the file. If we are dealing with large amount of data the XlsIO component  requires more system memory to preserve the details.

However, we need the following details to analyze further more on this memory issue.

1.Stack trace of the OOM exception occurs at your side.
2.The size of the large data you are using.
3.Whether you are looping through the rows and columns to write the data in to an excel file or using an ImportDataTable() method to import the data directly to an excel file
4.The System Configuration (RAM capacity, OS version and Bit version, Visual Studio version)

Also, Please update us with the large data set (data base file) with issue reproducing sample you are using at your side so that it will be more helpful for us to anlayze furhter more on this issue.

Please let me know if you have any further clarifications.

Thanks,
Sridhar.S