System Out of Memory Exception. I see the memory Stream is only flushed when saved. We have 1.5 - 2GB Datasets.
I am using EPPlus Version 3.1.3.0
We do the following in code.
We loop through
--> Create a Package
--> each table in the datareader
--> Add WorkSheet to the Package
--> Dispose Each table.
--> Save the Package.
Each Datatable is of a 300Mg Size up to 15 Tables out form the System.
This is causing a issue, I have logged this in detail @ https://epplus.codeplex.com/workitem/15085
I still want to be able to use EPPlus its very nice API. but is there a better way to free up a worksheet once we add it to the package.
Thank you for helping.
I had this problem, but I fixed it by switching the option of "Platform target
", from x86
to x64
or "Any CPU
". ( right click on the project, then select "Properties", then the tab "Build", then on "Platform target" select "x64" )
The problem is that for platform x86
you can use only about 1.8 GB of RAM. For platform x64
, you do not have this limitation.