I tried to make it create 5 sheets in a single workbook and save 1M rows in each sheet. To test the performance and robustness of this library, I decided to throw a large dataset at it.

The library is available for use via Nugget. Catching my attention from the various suggestions is EPPlus library which has been around for a while but never really had much publicity like OpenXML and ClosedXML.

The excel file being created had 5 sheets with around 400,000 rows each and ClosedXML could not handle this large amount of data.ДЄpparently a lot of folks have had the same issue using the library and many suggested different workaround or alternative libraries. Reviewing the logs indicated that the reporting module threw a System.OutOfMemory Exception which originated from ClosedXML. Recently, I had to resolve an issue of a corrupt report file of an enterprise application in production. Similar to OpenXML, ClosedXML is another elegant library that further simplifies the process of reading and writing to excel files and hides the complexities involved, without need of dealing with XML documents.

Open XML SDK makes it easy to manipulates documents that conforms to the Office Open XML file formats specifications with a trade-off of writing plenty lines of code. Net, manipulating Microsoft excel files from ASP.Net web applications was a daunting task. Prior to the availability of Open XML SDK and other Excel libraries in.

Save dataset as excel file c#