[FIXED] JavaFX netbeans 12.4. Added Poi to library but cannot use the import in the project

Issue

I have downloaded the most recent Apache poi from https://poi.apache.org/download.html and installed the jars into NetBeans by right-clicking libraries and selecting all the jars, and those in lib.

I'm then presented with these errors when trying to import and use poi in my project.

I have had a long look around and cannot find where I am going wrong here. Please could anyone point me in the right direction?

Solution

The error message indicates that the package org/apache/poi/xssf/usermodel is missing. The package is in poi-ooxml-5.2.2.jar, which should be added your library, as shown in How to use .jar files in NetBeans?. You can find other missing packages using the jar command, for example:

jar tf poi-bin-5.2.2/poi-ooxml-5.2.2.jar

Because not all of the JARs are needed for every document file format, see also Apache POI—Component Overview: Component Map and Apache POI: FAQ, item 3.

Answered By - trashgod
Answer Checked By - David Marino (JavaFixing Volunteer)