Four Js Development Tools Forum

Discussions by product => Genero BDL => Topic started by: ORGA-SOFT B. on February 04, 2018, 12:18:00 pm



Title: Getting the Apach POI Framework working
Post by: ORGA-SOFT B. on February 04, 2018, 12:18:00 pm
Hello,

i try to implement / test the Apacha POI Framework for microsoft office.
First of all i have downloaded the poi framework und unzipped the files to my project.
i also set the CLASSPATH Variable to the path where the poi jar files are stored.

If i compile the example from the documentation it always tells me that he can't find the java classes.
So what i'm doing wrong?

Greetings
Martin Stigmond


Title: Re: Getting the Apach POI Framework working
Post by: Stefan S. on February 04, 2018, 05:23:19 pm
Hi,

we use the poi-Framework on a Linux-Server and it is running fine...
I have to setup my LD_LIBRARY_PATH to the point where to find the libjvm.so


#export CLASSPATH=/opt/poi-3.13/poi-3.13-20150929.jar:$CLASSPATH
#export CLASSPATH=/opt/poi-3.13/poi-ooxml-schemas-3.13-20150929.jar:$CLASSPATH
#export CLASSPATH=/opt/poi-3.13/poi-ooxml-3.13-20150929.jar:$CLASSPATH
#export CLASSPATH=/opt/poi-3.13/ooxml-lib/xmlbeans-2.6.0.jar:$CLASSPATH
#export LD_LIBRARY_PATH=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.71-2.b15.el7_2.x86_64/jre/lib/amd64/server/:$LD_LIBRARY_PATH


Stefan


Title: Re: Getting the Apach POI Framework working
Post by: Reuben B. on February 04, 2018, 10:29:38 pm
Martin,

If you copy and paste the error message into your forum post, as well as any version information, (FGL, JAVA, ApachePOI) we might be able to assist you better.

Also if you try my example here https://github.com/FourjsGenero/fgl_apache_poi that might help see what is missing, make sure you see the note in README about setting of CLASSPATH, particularly the annoying fact that versions are included in the filenames so it is easy to have a numerical typo.

Reuben


Title: Re: Getting the Apach POI Framework working
Post by: ORGA-SOFT B. on February 07, 2018, 12:51:55 pm
I finally got it work!
So my problem was, that i have downloaded the version 3.17. In this version 1 file is missing that is referenced in the classpath
the missing file was: dom4j-1.6.1.jar. and i didn't referenced the jar files. I referenced only the folders.
So know finally i'm happy again.