EPPlus C# Multiple saves

I am using EPPlus library in asp.net + C# to generate .xlsx file. My file can hold a some million records and I am making one ExcelWorksheet per 100K records. issue is that a 40Mb xlsx that having almost 1.5M records my take multiple Gbs of main memory and after that i get an OutOfMemoryException problem is:
How do I reduce memory taken X Gb for 40M?:-| or save ExcelPackage gradually and deallocate memory (it appears that i can not save more than once and after that all package is disposed).
If there's no solution can somebody introduce a alternative for EPPlus (with almost all functions like styling worksheets and etc)

Get Source Code

  Views 166   Posted on : Thursday, March 21, 2013 10:41:13 AM
Related Tags:

Replies on "EPPlus C# Multiple saves" :

Nobody has replied on this post , be first to post answer.

Post Your Answer/Comment:

Please Login first to post Reply !

Note: Please Put Code into <code></code> block.

Also See: