How can I add the Apache POI Library in Eclipse


How can I add the Apache POI Library in Eclipse


Many times application requires excel to generate report or some time application expect excel file to read required data.  Example to design a testing framework we need several  excel file to read input data and expected output for validation purpose.

installation of POI in javaAny programs who wants to access MS office files like excel, word , power point as a output or input must be used predefined APIs.  Apache POI is one of them and it is very powerful and popular java API to access MS office files.

For better understanding I am going write down one program which will read one excel file using poi and print the value, I will explain each line .


Download & Installation process 


Before the code we need to download the latest version on the POI from http://poi.apache.org/download.html and unzip its contains to a folder.  After extracting the folder we need to add all jars in eclipse project build path.

Required jars in POI




Required jars which we need to add in our project build path




Required jars for POI





Required jars which we need to add in our project build path
Required jars for POI





Required jars which we need to add in our project build path






After adding jars in project build path

Add poi jars in eclipse


After adding all jars in project build path project is read to use Apache POI.