19

I know of some open source libraries for handling with Excel files but these are for only *.xls or *.xlsx, for example NPOI is for *.xls, EPPlus and ClosedXML are for *.xlsx. I don't want to use Microsoft Excel Automation because of the performance matter. Could you please suggest me with some open source or free library meeting this purpose (handle with both *.xls and *.xlsx).

Improve this question
8
  • This is discussed in detail here stackoverflow.com/questions/151005/…
    – Mudassir Hasan
    Commented Apr 13, 2013 at 17:59
  • 1
    For read or for write?
    – Joel Peltonen
    Commented Apr 13, 2013 at 18:16
  • Google "Free Opensource C# excel library"
    – Toby Allen
    Commented Apr 13, 2013 at 18:53
  • @Toby Allen, I don't think it's easy to Google for that, many open source libraries support only *.xls or only *.xlsx, so asking this question is not lazy for Google, also is not duplicated as some ones marked it. Even the link mhasan posted can't help to find a library supporting both xls and xlsx. If you think it's easy, please try and feel yourself.
    – King King
    Commented Apr 14, 2013 at 11:13
  • The most voted answer in the old question suggesting NPOI and EPPlus which don't satisfy my need. Why do you think this is a duplicate of that question? Looking at the question title, it seems to be a duplicate but the answers to the old question didn't care if those libraries can support both *.xls and *.xlsx.
    – King King
    Commented Apr 14, 2013 at 11:20

1 Answer 1

Reset to default
15

How about spreadsheetlight? Is open-source, with an MIT license.

Improve this answer
4
  • 1
    Microsoft release a compatibility pack for the older versions of excel to use the newer format. But if you need to support office 97 you would still need xls support.
    – Dreamwalker
    Commented Oct 31, 2014 at 16:48
  • You should add this answer to stackoverflow.com/questions/151005/… since this question is closed as a dupe and it looks like the best solution.
    – Chris Marisic
    Commented Aug 11, 2015 at 21:30
  • 1
    I take it back, spreadsheetlight doesn't work at all.
    – Chris Marisic
    Commented Aug 12, 2015 at 15:59
  • @WolfOdrade spreadsheetlight is the library which in turn uses Documentformat.OpenXML.
    – Kunal Kakkad
    Commented Dec 28, 2015 at 8:08

Not the answer you're looking for? Browse other questions tagged or ask your own question.