Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: [1]
  Reply  |  Print  
Author Topic: Getting the Apach POI Framework working  (Read 8412 times)
ORGA-SOFT B.
Posts: 34


« 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
Stefan S.
Posts: 90


« Reply #1 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
Reuben B.
Four Js
Posts: 1126


« Reply #2 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

Product Consultant (Asia Pacific)
Developer Relations Manager (Worldwide)
Author of https://4js.com/ask-reuben
Contributor to https://github.com/FourjsGenero
ORGA-SOFT B.
Posts: 34


« Reply #3 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.
Pages: [1]
  Reply  |  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines