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

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 30,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

Answer 1

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.

Answer 2

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