Creating Excel from RPG

35 pts.
Tags:
Java
I am trying create spreadsheets using Scott Klement's HSSF code. I’ve used it before on the iSeries but not on this system version (V7R2). Has something changed that no longer allows it to work? Installed the intro/sample of it from http://www.scottklement.com/poi/ POI Version 3.5 – 3.6 HSSFR4 RPG Utilities for POI/HSSF. When I try to run it at line 59 I get, “Java exception received when calling Java method.”
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    You may want to check that Java has been installed on the server.

    134,720 pointsBadges:
    report
  • oh254tw

    It has Java installed

    5770JV1   Java SE 8 32 bit and 64 bit

    35 pointsBadges:
    report
  • ToddN2000
    Can you post the block of code so can can better understand what it looks like?
    134,720 pointsBadges:
    report
  • oh254tw

    I'm not sure if the classpath is setup or if something has changed in the newer version of Java but when it

    56          ss_begin_object_group(100);         
    57                                              
    58          if (xssf);                          


    59             book = new_XSSFWorkbook();                                   (at this point I receive "Java exception received when calling Java method."     

    In the job log...                                                                                  Java exception received when calling Java method.                   received Java exception "java.lang.NoClassDefFoundError:      org.apache.poi.xssf.usermodel.XSSFWorkbook" when calling method "<init>"   with signature "()V" in class "org.apache.poi.xssf.usermodel.XSSFWorkbook".


    60          else;                               
    61             book = new_HSSFWorkbook();       
    62          endif;                              


             

    35 pointsBadges:
    report
  • ToddN2000
    Have you also downloaded the XLPARSER4 ?  I checked his spreadsheet on the topic and wonder if might be something else. I will say one thing about Scott Kelement, he is very good and does answer emails sent to him. I worked on a RPG CGI project a few years back and he was helpful, 
    134,720 pointsBadges:
    report
  • ToddN2000
    Correction I should have said his PDF not spreadsheet. Here's the link if you don't have it already.
    134,720 pointsBadges:
    report
  • oh254tw

    That is the link I used been trying to get HSSFR4 to work.  I used this at a previous job. but I don't remember what version they were running , we are on V7R2.  I read some place about someone who was running this same process but when they upgraded I believe to 7.2 it broke.  I wonder if something has changed on the Java part.  Are you doing anything with creating spreadsheets on the iSeries?


    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: