I need to add the apache poi to my project (I need hssf, ss and xssf). I downloaded a jar file from the internet but it does not contain xssf. I went to http://poi.apache.org/ and I downloaded this: http://www.apache.org/dyn/closer.cgi/poi/release/src/poi-src-3.9-20121203.zip, I extract it..and got stucked. I tried Part 1 but that was only for JavaDoc.
Apache POI provides libraries for reading and writing excel file in Java. There are other libraries available in market but Apache POI is most popular and reliable among them. Java Read and Write Excel File Using Apache POI. Download Apache POI Library. Go to below link and download the binary distribution of latest version.
How should I proceed from here?
Apache POI is a 100% open source library provided by Apache Software Foundation. Most of the small and medium scale application developers depend heavily on Apache POI (HSSF + XSSF). So what you should do is to go the Apache site (not that other site you went to) and download the latest version of the Apache POI jars. Put them in your Java stuff directory and set up your class path accordingly.
2 Answers
Download The latest stable release: Apache POI 3.16-FINAL distribution,
open your eclipse project properties,
Java Built Path > Libraries > Add external JARs,
then extract the zip file you downloaded and navigate the extracted folder,
select all the JARs under the sub folders (docs, lib, ooxml-lib),
then finally in the Order and Export section put marks to jar libs you just added,
and click OK.
Promoting a comment to an answer
You should head to the Apache POI Download Page, and then download the binary release. The binary releases have -bin- in their file names. The binary releases contain the POI jars, and their dependencies.
What you've downloaded with -src- in the name is the source package, which contains everything you need to build Apache POI yourself, but if you just want to get started you're much better off with the pre-compiled binary package.