Question posted 2012 · +7 upvotes
First of all, hello to everybody!
I have a piece of code which is creating an Excel file by using an open source library named OpenXLS-6.0.6. My pc has Windows XP Professional and Office 2003. However I have notice that since I have migrated to Windows 7 and Office 2010, I am not able to open the generated Excel file anymore. I went to the OpenXLS website and indeed is specified that: “Compatible with Excel ’97-2003 (.xls) file formats “
So here is my question: is anybody aware of a library that is able to generate Excel files compatible with Office 2010? I had a quick check on ExcelAPI and POI, but it is mentioned that they deal with Excel up to the Office 2003 version(at least this was my understanding).
Thank you very much in advance and kind regards, Marius
Accepted answer +3 upvotes
There is Apache POI. It is not the easiest library to use, but creating Excel files is the easiest thing that you can do with it. How to., How to 2. I have also seen commercial libraries that have free versions too.
XSSF is the POI Project’s pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.
Xlsx is also used in Office 2010.
External references cited (2)
- poi.apache.org — Apache POI
- sanjaal.com — How to
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.