Geek Answers Handbook

Which is the best API for reading large Excel files in Java?

what my application needs

1) Read large Excel files with .xls or .xlsx formats

2) insert each column as a row in the database with the previous column as the parent of the next

means that if I have 5 columns and 30,000 rows, then I want to insert 1 column as a parent,
The 2nd column is the child of the 1st column, the 3rd column is the child of the 2nd so on ... i.e. tree structure

Now someone can offer me the best API for this in java language.

after some googling, I found that there are many APIs, but this is the best of them.

Link see

+4
source share
4 answers

Try the POI, I'm not sure if they read .xlsx, maybe they do in the newest versions.

+4
source

I have used POIs and JExcel in the past and are tied to JExcel because it is easier to use with better documentation. I also found that the POI uses more memory when writing data to a spreadsheet.

I would recommend JExcel, and I would be happy to help if you have any problems.

+5
source

And you can not export the CSV file?

This can be a much quicker solution and then analyze the entire .xls / .xlsx file. Another thing is that you need to deal with only one type / file format.

0
source

Try the POI - it will read the file (XLS, XLSX), but other libraries and basic JDBC are needed to manipulate the database.

-one
source

More articles:


All Articles