better open source for Excel file parsing

Hi,
I would like to know Which is better open source for Excel file parsing in Java. Does APACHE POI supports writing to excel file(along with reading excel file).What are the advantagesa dn disadvantages, practical uses of each approach.Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
LVL 7
gudii9Asked:
Who is Participating?
 
Amitkumar PConnect With a Mentor Sr. ConsultantCommented:
Apache POI is the good one... even you can work with Word document also.

Yes, you can do read and write with the excel along with the formatting also.
0
 
ariohConnect With a Mentor Commented:
You can't create charts and pivot tables with POI. That's why I'm using OpenOffice/LibreOffice at my work.
0
 
gudii9Author Commented:
>>>Apache POI is the good one... even you can work with Word document also.


Can we work with text documents too?

>>pivot tables with POI

what are pivot tables

Please advise
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ariohCommented:
0
 
Amitkumar PSr. ConsultantCommented:
Refer http://poi.apache.org/spreadsheet/examples.html for POI examples.

POI supports for both .xls as well as .xlsx
0
 
gudii9Author Commented:
Can we work with text documents too using POI. Please advise
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.