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.
Any 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 which we need to add in our project build path
Required jars which we need to add in our project build path
Required jars which we need to add in our project build path
After adding jars in project build path
After adding all jars in project build path project is read to use Apache POI.