How can I add the Apache POI Library in Eclipse - for Selenium Webdriver project?

10
votes

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.

How should I proceed from here?

2
apacheseleniumwebdriverapache-poi
Did you try downloading the binary release (contains jars and dependencies) instead of the source release? – Gagravarr
I tried your solution (which had the jars) and it worked. Thank you for being so prompt! – Maria

2 Answers

23
votes

  1. Download The latest stable release: Apache POI 3.16-FINAL distribution,

  2. open your eclipse project properties,

  3. Java Built Path > Libraries > Add external JARs,

  4. then extract the zip file you downloaded and navigate the extracted folder,

  5. select all the JARs under the sub folders (docs, lib, ooxml-lib),

  6. then finally in the Order and Export section put marks to jar libs you just added,

and click OK.

16
votes

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.