What is Apache POI and how to Download it

Author : Ashwini Velapure (Test Automation Engineer) https://www.linkedin.com/in/ashwinivelapure

APACHE POI

What is Apache POI?
Apache POI is a powerful Java library to work with different Microsoft Office file formats such as Excel, Power point, Visio, MS Word etc.

In this API we can handle different types of excel files. Most of the interviewer don’t satisfied with only JXL.It is good to know about APACHE POI
Here, we go for Apache POI.


STEPS FOR GETTING APACHE POI:

• Download ‘poi-bin-3.14.tar’ file from https://poi.apache.org/download.html

• Extract the above .tar file to any folder
• Right Click on Eclipse Project->Build Path->Configure Build Path->Libraries->Add external jar.
• The following jar files needs to be added

    

• Under ooxml-lib folder

         

• Under lib folder

            

• Brows all the above the poi jar file and add it
• Here you can access the all Apache POI classes.