Test best library and solution to use when exporting very large data to excel files in .NET Framework
- 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)
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
this library actually has the best performance, especially when using OpenXMLWriter directly