How to add Apache POI library in Eclipse - for Selenium Webdriver project?

I need to add apache poi to my project (I need hssf, ss and xssf). I downloaded the JAR file from the Internet, but it does not contain xssf. I went to http://poi.apache.org/ and downloaded this: http://www.apache.org/dyn/closer.cgi/poi/release/src/poi-src-3.9-20121203.zip , I extracted it .. and stuck. I tried part 1, but that was only for JavaDoc.

What should I do from here?

+7
source share
4 answers
  • Download the latest stable version: Apache POI 3.16-FINAL ,

  • open the properties of the eclipse project,

  • Java Built Path> Libraries> Add External JARs,

  • then extract the downloaded zip file and move the extracted folder,

  • select all JARs in subfolders (docs, lib, ooxml-lib),

  • then finally, in the Order and Export section, add tags to the jar libs you just added,

and click OK.

+16
source

Advance comment comment

You must go to the Apache POI download page and then download the binary version. Binary releases have -bin- in file names. Binary releases contain POI banners and their dependencies .

What you downloaded with the name -src- in the name is the source package that contains everything you need to create the Apache POI yourself, but if you just want to get started, you are much better off with a pre-compiled binary package.

+14
source

Download the latest stable binary distribution, for example: https://www.apache.org/dyn/closer.lua/poi/release/bin/poi-bin-4.1.0-20190412.zip or http: //poi.apache. org / download.html # POI-4.1.0 . Add all the .jar files you can find in the folders.

0
source

I could solve this problem by adding jar Apache POI files to the path to the TomCat class in Eclipse (see class path): https://help.eclipse.org/neon/index.jsp?topic=%2Forg.eclipse. stardust.docs.wst% 2Fhtml% 2Fwst integration% 2Fconfiguration.html

0
source

All Articles