Java to Excel 2010

Question

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 "

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).

Answer 1

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.