which is the best API to read large sized excel files in Java? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

what my application needs are

1) Read large sized excel files with .xls or .xlsx format

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

means if i am having 5 columns and 3开发者_如何学编程0,000 rows then i want to insert 1 column as parent,

2nd column is child of 1st column, 3rd column is child of 2nd so on...i.e. tree structure

now can anyone suggest me best API to do this in java language.

after some googling i found there are lots of API's present but which is the best out of that

Reference see

---

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

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

---

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

---

And you can't do an export to a .csv file?

This would maybe be a much faster solution then parsing the whole .xls/.xlsx file. Another point is that you than only have to deal with one file type/format.

---

Try POI - it will read the file (XLS, XLSX) but the database manipulations require other libraries and basic JDBC as well.