What is the best API to read large excel files using Java?

java apache-poi large-files jexcelapi
ashishjmeshram picture ashishjmeshram · Feb 14, 2012 · Viewed 13.1k times · Source

I need to read large excel sheets using Java. The Excel sheet may be .xls or .xlsx. The sheet may have thousands of rows. I have to read all rows and insert that row in the database.

So basically read from Excel and write in database.

The APIs that I am considering are POI and JExcel API (After googling and reading some other related articles in SO).

But I am still not sure as to what is the most appropriate way of reading very large Excel sheets.

I don't want to have any memory issues later on.

Edit 1:

Also, from what I have searched so far it seems that JExcel does not support .xlsx formats.

Please suggest.

Answer

jpstrube picture jpstrube · Feb 14, 2012

We are reading Excel files of that size using Apache POI without problems.

Related questions

How can I read numeric strings in Excel cells as string (not numbers)?

I have excel file with such contents: A1: SomeString A2: 2 All fields are set to String format. When I read the file in java using POI, it tells that A2 is in numeric cell format. The problem is that the …

Read More
Apache POI Excel - how to configure columns to be expanded?

I am using Apache POI API to generate excel spreadsheet to output some data. The problem I am facing is when the spreadsheet is created and opened, columns are not expanded so that some long text like Date formatted text …

Read More
How do I set cell value to Date and apply default Excel date format?

I've been using Apache POI for some time to read existing Excel 2003 files programmatically. Now I have a new requirement to create entire .xls files in-memory (still using Apache POI) and then write them to a file at the end. …

Read More