HSSFR4 Java exception received when calling Java method.

[Luigi Brito]

Trying out the HSSFR4 from Scott and running the

XLCRTDEMO PARM('1')

I completely fail at new_XSSFWorkbook();

I ran the installation as per Readme. What I am unable to confirm at pub400 is below from hssfr4.rpgle.

EDIT: I found i have no access to /QIBM/UserData/Java400/Ext on both pub400 and rikas and may have no chance to install jar and test this out sadly. I tested on qsh with

touch test.txt

Anyone know of an ibm i online account where I can install POIs and try things out?

      *  Licensed program requirements to compile:
      *   - ILE RPG Compiler (57xx-WDS, opt 31)
      *   - IBM Developer Kit for Java (57xx-JV1, *base)
      *   - One of the Java Developer Kit 5.0 or higher (57xx-JV1, opt 7+)
      *   - System Openness Includes (57xx-SS1, opt 13)
      *   - QShell (57xx-SS1, opt 30) not required, but highly recommended
      *
      *  Licensed program requirements at run-time:
      *   - One of the Java Developer Kits (57xx-JV1 opt 5,6,7, or 8)
      *   - Apache POI version 3.5 or higher (in CLASSPATH)
      *
      *  To use the XLSX (New Excel in XML format) support
      *  some additional JAR files are required.  (listed below)
      *
      *  This service program was tested with the following JAR files.
      *  Newer versions of these JAR files may also work, but these
      *  are the versions I tested it with:
      *
      *  FROM APACHE POI 3.6:
      *   - poi-3.6-20091214.jar
      *   - poi-contrib-3.6-20091214.jar
      *   - poi-examples-3.6-20091214.jar
      *   - poi-ooxml-3.6-20091214.jar
      *   - poi-ooxml-schemas-3.6-20091214.jar
      *   - poi-scratchpad-3.6-20091214.jar
      *
      *  FROM DOM4J 1.6.1 **:
      *   - dom4j-1.6.1.jar
      *
      *  FROM XMLBEANS 2.5.0 **:
      *   - jsr173_1.0_api.jar

* - xbean.jar

[JonBoy]

I would ask the folks at Pub400 to make it available. It is really no different to having PHP, Python, RPG or anything else available.

[Scott Klement]

Don't put stuff in the 'ext' directory.

Instead, create a directory of your own, install the JAR files therein, and add them to your CLASSPATH.

[Luigi Brito]

Got it. I have access to my /home/username IFS I'm thinking to place jar files there and set it to the classpath. WIll let you know the results

[Luigi Brito]

Don't put stuff in the 'ext' directory.

Instead, create a directory of your own, install the JAR files therein, and add them to your CLASSPATH.

Thank you sir! I will and let you know the results

[Luigi Brito]

Hi. I've managed to make it work without the parm ('1'). I'm still failing on new_XSSFWorkbook with java exception

The jar files below are no longer available on xmlbeans. There's only a single xmlbeans-3.1.0.jar file now

[LIST][*]jsr173_1.0_api.jar from XmlBeans 2.5.0 (or higher)[*]xbean.jar from XmlBeans 2.5.0 (or higher)[/LIST]

My classpath

 Value . . . . . . . . . :   '/home/britol/POI36/poi-3.6-20091214.jar:/home/britol/domj/dom4j-1.6.1.jar:/home/britol/xbean/xmlbeans-3.1.0.jar'

for xmlbeans, I could no longer find where the xbean.jar is I could only see xmlbeans-3.1.0.jar. I can't find anything on xbean.jar anywhere anymore.

[Scott Klement]

I haven't worked with POI in 8 years, so I don't know what the current files should be.

I've attached the xmlbeans file from 2012, when I last worked with it. Hope that will help you.

[Luigi Brito]

Thanks, I'll try this out in a few days time and let you know the result