Geek asks and answers

Many EPPlus Saves

I am using EPPlus's library asp.net + C#to create a file .xlsx. My file can contain several million records, and I create one ExcelWorksheetfor 100 thousand records. the problem is that a 40Mbxlsx containing almost 1.5Mwrites my take of several Gbs of main memory, and after that I get OutOfMemoryException, the question: How to reduce the amount of memory X Gb for 40M?: - | or save ExcelPackagegradually and free up memory (it seems that I cannot save more than once even after the whole package is located).

If there is no solution, can anyone introduce an alternative for EPPlus (with almost all the features like styling, worksheets, etc.)

+5
source share
2 answers

This issue seems to be resolved in the latest version of EPPlus (4.0.x)

EDIT: Add link links to pages that indicate improved memory management in EPPlus 4.0.4.

https://epplus.codeplex.com/releases/view/118053#ReviewsAnchor User reviews about memory performance improvements in version 4.x in comparison with the 3.x version .

https://epplus.codeplex.com/wikipage?title=Roadmap Version 4.0: a new cell to improve insertion, removal of performance and memory consumption

This link explains how to optimize the loading of a large number of cells.

http://epplus.codeplex.com/wikipage?title=FAQ&referringTitle=Documentation " , . , ?"

, EPPlus 4.0.4 , 1,5 5 1 DateTime, , Windows, 711 , , Windows, 75 . ! , , , . Excel 59 (, , , .)

. "OutOfMemoryException", 4,5 7 !

? , ... , .

, , , - xlsx 100 . . ( ) 100K .

10 100K , , 1 .

, , , , , - ( ).

+4

. , , , . , . , .

AFAIK .NET Open XML SDK . EpPlus. - .

+4

More articles:


All Articles