Java Library to read Microsoft Excel files

Question

I want to write a program that compares two Microsoft Excel sheets using Java.

Is there any existing library (and its documentation) that can help me get started with basic stuffs like reading all the rows and columns of the excel ?

Solution 1

Have a look at Apache POI, which is a Java API for Microsoft Documents.

And here is a tutorial on how to setup and get started with Excel files.

Solution 2

1. Apache POI

Apache POI, a project run by the Apache Software Foundation, and previously a sub-project of the Jakarta Project, provides pure Java libraries for reading and writing files in Microsoft Office formats, such as Word, PowerPoint and Excel.

http://poi.apache.org/

2. docx4j

docx4j is a Java library for creating and manipulating Microsoft Open XML (Word docx, Powerpoint pptx, and Excel xlsx) files.

http://www.docx4java.org/trac/docx4j