We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Writing large file from IDataReader, out of memory?

Thread ID:





108131 Apr 4,2013 08:24 PM UTC Apr 8,2013 04:55 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On April 4, 2013 08:24 PM UTC

Good Afternoon,

I am working with what looks like version, 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,



Sridhar [Syncfusion]
Replied On April 8, 2013 04:55 AM UTC

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.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon