What is the best way to read and write data from excel using java?

Question

I am currently developing an app using java, the main aim is to read some data from excel to do some operations on them and write it to a new excel file. Actually I have did some research to find the best way, I have seen some people using POI and some others are using APIs. What you guys recommend for that? Thanks alot

score 1 · Accepted Answer · answered Apr 14 '17 at 01:13

1

I agree , POI its an excelent option https://www.tutorialspoint.com/apache_poi/apache_poi_java_excel.htm

answered Apr 14 '17 at 01:13

Luis Leal

3,388
5
26
49

score 0 · Answer 2 · edited May 23 '17 at 12:09

0

i used POI in my solution, it is strong and powerful. more choice please refer to : How to read and write excel file in java

edited May 23 '17 at 12:09

Community

1
1

answered Apr 14 '17 at 01:15

Xinyuan.Yan

116
1
7

score 0 · Answer 3 · answered Apr 14 '17 at 01:57

0

I have used both Apache POI and JXL. However, I prefer Apache POI, because it has everything you'll ever need while handling Excel files, no matter which version either 2003 or 2007 formats. The strength and flexibility are amazing.

answered Apr 14 '17 at 01:57

Apurv Chatterjee

165
1
13

What is the best way to read and write data from excel using java?

3 Answers3