Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello,
I'm looking for open source library to read & write very large excel files.Currently we are using EPPlus ,but they started to charge from the new release.So im looking for similar plugin which performs as good as EPPlus but should be open source.Please help me finding a solution ?
Thanks in advance

What I have tried:

I found few plugins like Npoi,Closed Xml which are popular but i see they have issues like memory leakage and couldn't handle large data sets.
Posted
Updated 11-Jun-20 2:41am
Comments
#realJSOP 11-Jun-20 8:38am    
are they excel files?
Nagavarsha Jasti 12-Jun-20 0:58am    
Yes

1 solution

I use a parser called ExcelDataReader. It's available via NuGet. Depending on the size of your files, it still may not be adequate, though. You'll have to make that determination on your own.

EDIT ========================

I wrote an article and posted it here: CSV/Excel File Parser - A Revisit[^]

Feel free to experiment with your own files...
 
Share this answer
 
v3
Comments
Nagavarsha Jasti 12-Jun-20 1:01am    
Excel sheet may contains one million records.Do excelDataReader handles this large files without crashing or slowdown.Any idea?
#realJSOP 12-Jun-20 7:45am    
How should I know? Didn't yopu read the part of my answer that said you have to determine that on your own?
Nagavarsha Jasti 12-Jun-20 9:46am    
As you are already using, just want to know how big files you are handling
#realJSOP 12-Jun-20 15:48pm    
Edited my answer
Nagavarsha Jasti 12-Jun-20 17:12pm    
sure,thankyou

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900