Netbeans add library Apache Poi Java API

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

Creating Apache Poi library - Netbeans add library

Creating Apache Poi library


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:

ApachePoi Library Class path - Netbeans add library

Now simply browse directories and incorporates your file:

Add Apache Poi jar library - Netbeans add library

Add Apache Poi jar library


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:

ApachePoi Library Add Docs - Netbeans add library

ApachePoi Library Add Docs


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.

Java leer excel con Apache Poi Java API

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

8 responses on “Netbeans add library Apache Poi Java API

    1. Julio Yáñez Novo Post author

      Hola Edu.

      Mis ejemplos con Apache POI están hechos en Ubuntu 15.10, revisa bien que Jdk está usando tu sistema y NetBeans por su hubiese alguna incompatibilidad de la librería que puedes comprobar en la documentación de Apache POI.

      Espero que te sirva de ayuda.


  1. Lewis

    Hmm it seems like your blog ate my first comment (it was super long) so I guess I’ll
    just sum it up what I wrote and say, I’m
    thoroughly enjoying your blog. I too am an aspiring blog blogger but I’m still new to the
    whole thing. Do you have any tips for beginner blog writers?
    I’d definitely appreciate it.

  2. Carlos

    Estimado, siempre de gran ayuda todo lo que aportas. Tal vez estaria bueno explayarse un poco mas en como encontrar las librerias y cuales tomar, luego de mucho tiempo de buscar y leer, recien pude incorporar las librerias y lo mas importante pude saber CUALES importar ya que en Apache Poi hay muchas y el que no conoce no sabe cual tomar. Lo mismo con el Javadoc, todavia no logro saber donde y cuales cargar. GRACIAS.

  3. Felipe

    Agradezco la ayuda con el siguiente error
    Exception in thread “main” java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap
    at creararcexcel.CrearArcExcel.main(
    Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap
    at java.lang.ClassLoader.loadClass(
    at sun.misc.Launcher$AppClassLoader.loadClass(
    at java.lang.ClassLoader.loadClass(
    … 1 more
    Line 36: XSSFWorkbook libro= new XSSFWorkbook();

Leave a Reply

Your email address will not be published. Required fields are marked *