Java libraries that work with Microsoft Office documents but do not depend on automation

Question

By "not depend on automation", I mean that it should not require a Microsoft Office installation to work; let alone interact with a live instance of a Microsoft Office component. One such library is Aspose.Total for Java. Are there any more out there?

Another solution I'm considering is to use OpenOffice.org. However, I'm not sure if I'm going to run into the same problems as with Microsoft Office as detailed here.

What do you want ? A library to read/write office documents ? Or a library to interact with a live instance of Office (like Office macros written in Java) ? — Riduidel
– Riduidel, Commented Jan 19, 2011 at 13:56
Edited question body to reiterate condition in question title. — Chry Cheng
– Chry Cheng, Commented Jan 19, 2011 at 13:59

Mark · Accepted Answer · 2011-01-19 14:35:38Z

3

For Office Documents: http://poi.apache.org/

I have not tried this myself, but Apache usually deliver good libraries

For just Excel: JExcel API for Java

I use this for one application, and it works quite well. May use a fair bit of RAM for larger documents.

edited Jan 19, 2011 at 14:35

Mark

29.2k8 gold badges66 silver badges94 bronze badges

answered Jan 19, 2011 at 14:12

smat

4893 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael McGowan Over a year ago

In my limited experience with Apache POI, it also appeared to use a lot of RAM for larger documents (specifically large Excel documents).

Michael Berry · Accepted Answer · 2011-01-19 14:37:59Z

1

One designed specifically to with with the newer XML formats is docx4j: http://dev.plutext.org/trac/docx4j

answered Jan 19, 2011 at 14:37

Michael Berry

72.8k23 gold badges165 silver badges227 bronze badges

Comments

will · Accepted Answer · 2011-03-16 13:46:57Z

There are two further answers for this question. Depending on your application.

can borrow from the OpenOffice library code that deals with opening and saving MS Office files. (See: http://www.artofsolving.com/opensource/jodconverter or jOpenDocument )
You might just use OpenOffice itself by scripting or automating that.

I faced this question a while back with a Ruby app and because I was in control of the source document, I got the originator to save things as HTML format and used Tidy to filter the junk. Another option it to find a tool to convert the Office files to RTF which is more generic.

Another to consider ...

LibreOffice looks useful.
jExcelAPI if you just want excel.
Finally there are some opportunities on sourceForge, try this search: http://sourceforge.net/search/?q=java+ms+office

You may find spreadsheets BIG unless you use OpenOffice or MS Office because you need to have a fancy shamancy virtual sparse matrix to do what they do well.

Ashwin Jayaprakash · Accepted Answer · 2011-08-19 18:56:30Z

0

ODF Toolkit - http://odftoolkit.org

answered Aug 19, 2011 at 18:56

Ashwin Jayaprakash

2,1861 gold badge26 silver badges30 bronze badges

Collectives™ on Stack Overflow

Java libraries that work with Microsoft Office documents but do not depend on automation

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related