Handling Excel file in Java

Question

I have a Excel file that I have to read the file and go line by line and check the first column. Here is an example of the column headers

ISBN#13 Run Date    Title   Author  Type

So I have to check each ISBN#13 and determine if it is an isbn#13, format it and write the whole line to a file. Then take all the ones that are not ISBN#13 and write them to a file.

So the question is how do I check the column "ISBN#13" and how do I write each row to a file. It would be another excel file.

Answer 1

Go for JXLS
Here are some sample code

Answer 2

Take a look at this project and related documentation:

http://poi.apache.org/

Answer 3

You might want to check Reading Excel using Apache POI for this.

Answer 4

There is also xslx4j (part of docx4j) if you are working with xlsx only (ie not the legacy binary .xls) and prefer to use jaxb