Is there any Java library which supports both Microsoft office and Open Office?

Question

As Apache POI supports Microsoft office and JExcelApi supports Open Office, is there any Java library which supports both Microsoft office and Open Office?

Note: In the pom.xml file we are using either POI and JExcel utilities in order to fetch/read data from the Excel sheet in Microsoft office and Open Office respectively.

So my question: Is there any library which supports both?

jexcelapi.sourceforge.net states that JExcel API supports Excel 95, 97, 2000, XP, and 2003 workbooks. There's no word about Open Office. Anyway, OO has its own Java API (guide). I don't know any library that would be able to open both MS and OO documents. — Petr Janeček
Why do you need one library that supports both? You could also just use two libraries, one for MS Office and one for Open Office support. — Jesper
What do you need to do? Get text out? Read rich values? Write changes? — Gagravarr

Supun Sameera Supun Sameera · Accepted Answer · 2013-10-07T10:28:22

Aspose covers all of Microsofts formats, but it is not free and not open source.

Regarding open source Java API, you can find a review on each available java library here,

http://www.esupu.com/open-source-office-document-java-api-review/

Apache UNO Java library supports all according to my knowledge and it's free and open source but it need a Open Office installation to process and it's documentation is heavy and not that much clear

Is there any Java library which supports both Microsoft office and Open Office?

3 Answers