Step 7 – After that, once all the POI JARs add, click on the Apply and Close button as highlighted below. Step 6 – Select the JARs under the lib folder in the unzipped POI folder as highlighted below. Step 5 – Next, select the JARs under the ooxml-lib folder in the unzipped POI folder as highlighted below: Subsequently, click on the Open button to include them in the Eclipse project. Step 4 – Select the JARs in the parent folder of the unzipped POI files. Finally, click on the Add External JARs as highlighted below. Step 3 – It will open the “ Properties ” of the project.

Step 2 – To add POI libraries to this project, Right-click on the project, hover over the Build path, select Configure Build Path. Step 1 – Below is the Java project present in Eclipse. Step 4 – Once POI.zip is downloaded and extracted, this is how the folder looks like I have used highlighted link to download the POI library files. Step 2 – After clicking on the link, it navigates to another page as shown below. Download any one of the Binary Distribution options. Here, you can see POI 5.0.0 is the latest one. Step 2 – This page shows the latest Apache POI Release Artifacts. This link will navigate to the page showing the latest release of Apache POI.

Click on the Download as shown in the image. Step 1 – To download Apache POI, go to its official site, here. But, there are various libraries in JAVA which helps in reading/writing data from Excel files. Apache POI is one of the most used libraries, which provides various classes and methods to read/write data from various formats of Excel files(xls, xlsx etc).Īpache POI, where POI stands for (Poor Obfuscation Implementation) is the Java API for Microsoft Documents that offers a collection of Java libraries that helps us to read, write, and manipulate different Microsoft files such as excel sheets, power-point, and word files. Selenium does not have inbuilt method to read data from Excel File. This tutorial describes how to download and install Apache POI.

Poi apache jar download