We are going to add the library Apache POI – the Java API for Microsoft Documents, that provides access to different file types Microsoft that use this structure as Excel, Word or Powerpoint, there are other projects in this API to Visio and Publisher for example all these the more developed Excel Workbooks.
Netbeans add library Apache Poi Java API
Download API Apache Poi Java library to add to our project in Netbeans can add the jar file directly, or, as I will explain here, add it by creating a library that can easily add other projects, will be similar in the other IDES how to integrate the libraries.
In our project we look up we stand Libraries folder and select Add Library, not much to explain so I’ll show you in pictures below.
Netbeans add library – Creating our library for Apache POI
As seen in the image we name our library, I call ApachePoi, use names that easily identify the library, if a library with many updates, it is important that you indicate the version. También indicamos de que tipo es, en nuestro caso Class Libraries:
We also indicated that type is, in our case Class Libraries
Netbeans add library – Add Apache Poi jar
After the creation of the library, It opens the window as you can see in the picture where youseek the location of our file jar by pressing Add Jar/Folder button as you can see in the picture.
After creating the library window where the image look for the location of our jar file by clicking the Add Jar / Folder button as you can see in the picture opens:
Now simply browse directories and incorporates your file:
Netbeans add library – Adds Apache Poi docs
Here select the Javadoc tab click the Add Zip /Folder button, or also the option Add url, in this case, we add through the docs folder that we are provided in the download, simply press the button and seek the docs folder, as seen in the image:
I hope it has been usefulXules
What do we do now?
Then I leave for you to continue learning links reading and writing Excel spreadsheets with Apache POI – the Java API for Microsoft Documents.
We will create the class of utilities JavaPoiUtils where we will create methods for learning and reading and sheet processing excel in JavaCódigo Xules
Java write excel with Apache Poi Java API
Soon … Código Xules