Click here to Skip to main content
14,604,663 members
Rate this:
Please Sign up or sign in to vote.
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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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...
   
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100