Test best library and solution to use when exporting very large data to excel files in .NET Framework
Rerferences
project & test documentation
knowledge references
- Writing Large Excel Files with the Open XML SDK
- Export big amount of data from XLSX - OutOfMemoryException
- How to properly use OpenXmlWriter to write large Excel files
- Working with the shared string table (Open XML SDK)
Conclusion
NPOI、ClosedXML etc
these libraries will keep excel data in memory, so if the DataTable to export has very large scales(Let's say more than 600,000+), the memory usage will be extremely high
OpenXML
this library actually has the best performance, especially when using OpenXMLWriter directly