SRSridhar Syncfusion Team April 8, 2013 04:55 AM UTC
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.