RE: XLPARSER4 question

Peter:

According to this page:
http://www.easy400.net/hssfcgi/documentation/20100311.html

the new version of HSSFR4 "... can create both of Excel's native formats .XLS and .XLSX."

Looking at the article (linked to in the above page):
http://iprodeveloper.com/system-i-network/new-poi-release-brings-excels-xlsx-support-rpg

this article has a section on "Writing Format-Independent Code" that describes coding changes to allow your application to handle both .XLS and .XLSX formats.

HTH,

Mark S. Waterbury

> On 11/26/2014 12:12 AM, Colpaert, Peter wrote:

I have meanwhile discovered it was (probably) an activation group and/or binding directory problem.

My compile command didn't contain 'ACTGRP(XLPARSE) BNDDIR(QC2LE)'.

I added it and now it's working, albeit only for .xlsx files.

If I run my program for an .xls file, I get a java error:

Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 26/11/14 Time sent . . . . . . : 06:10:15

Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure XLPARSE_WO in program XLPARSE36/XLPARSER4
received Java exception "java.lang.NoSuchMethodError:
org/apache/poi/hssf/record/SSTRecord.getString(I)Lorg/apache/poi/hssf/r"
when calling method "parse201003" with signature "(¬B)V" in class
"com.iseriesnetwork.clubtech.xlparse.ParseSheet".
Recovery . . . : Contact the person responsible for program maintenance to
determine the cause of the problem.
Technical description . . . . . . . . : If the exception indicates that the
Java class was not found, ensure the class for the method is in the class
path. If the exception indicates that the Java method was not found, check
the method name and signature. If the signature is not correct, change the
RPG prototype for the method, or change the Java method, so that the return
type and parameter types match. You can determine the signatures for all the
methods in class XYZ using command QSH CMD('javap -s XYZ').

Even though I could live with having to convert all files we need to process to .xlsx, it would be nice if the service program were backward compatible.

Any clues?

Met vriendelijke groeten / Best regards,

Peter Colpaert
Software Engineer - PLM Development Team
IT Operations Cluster Benelux, Philips IT

Philips Consumer Luminaires
Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel: (+32) 3/459 13 17
Email: Peter.Colpaert@xxxxxxxxxxx

Working from home on Wednesdays