DOWNLOAD Apachi POI

Apache provides a library POI using which read and write of an excel can be performed in Selenium WebDriver. Using it the read and write operation of both xls and xlsx file formats can be done. So first you need to download the Apache POI and configure it (jar files) in your eclipse. Implement the following steps to read an excel file
Step-1 :-
• Open Google
• Search for “Apache POI”
• Click on the Link “Apachi POI-Download Release Artifacts”
download-apachi-poi1

Step-2 :-
• Click on the Link “POI-bin 3.14 zip”
download-apachi-poi2

Step-3 :-
• Click on the link “http://www.apache.org/dist/poi/release/bin/poi-bin-3.14.zip”

download-apachi-poi3
Step-4 :-
• After Downloading Extract ZIP file
• Open the Folder Add Below Shown Jar files into Eclipse Project as Mentioned In the Next step
download-apachi-poi4

Step-5 :-
• Open Eclipse
• Go to Project Right Click Choose BuildPath Option
• Again choose Configure Build Path in The SubMenu

download-apachi-poi5

Step-6 :-
• In the Window That Opens Go to Libraries tab
• Click on Add External Jar file button
download-apachi-poi6
Step-7 :-
• Browse and Choose Required Jar files To be Added to the Project
• As mentioned in the Step-4
download-apachi-poi7
Step-8 :-
• Click on Apply
• Click on Ok

download-apachi-poi8

Step-9 :-
• Once All Jar files Are added U will see those things under the Reference Libraries file
download-apachi-poi9

Leave a Reply

Your email address will not be published.