[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Excel Spreadsheets



Hello All,

I sent this out last week and decided to send it out again.

I need to generate a chart (pie or bar) in an excel spreadsheet via an
RPG program. Currently poi does not
support charts. Scott suggested that I parse a template chart into my
RPG program, change the variables
and then send the chart back to the ifs. I'm testing that suggestion.

I've downloaded Scott's parsing examples and am trying to run the
XLPDEMO program, which parses a .xls 
file into a RPG program. I'm getting the following error messages:

------------------------------------------------------------------------
--------------------------------------

                         Additional Message Information


Message ID . . . . . . :   RNX0301

Date sent  . . . . . . :   04/22/09      Time sent  . . . . . . :
09:34:56   

Message . . . . :   Java exception received when calling Java method.

Cause . . . . . :   RPG procedure XLPARSE_WO in program
DTECHEXCEL/XLPARSER4 received Java exception
"java.lang.NoSuchMethodError: getString
(I)Ljava/lang/String;" when calling method "parse" with signature
"([B[B[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').  
               

                         Additional Message Information

Message ID . . . . . . :   RNQ5335

Date sent  . . . . . . :   04/22/09      Time sent  . . . . . . :
09:34:56  

Message . . . . :   DSPLY  Error occcured while parsing spreadsheet.

Cause . . . . . :   This is an inquiry message originated from RPG
procedure XLPDEMO in program DTECHEXCEL/XLPDEMO. The program is
expecting a
character input field with a maximum length of 1.

Recovery  . . . :   Enter a valid response according to the type of
data expected by the program.  The program will tolerate five incorrect
responses before signaling an error condition.  There have been 0
incorrect
responses so far.  If you do not want to enter any data, just press
Enter to
resume processing of the program.   

------------------------------------------------------------------------
--------------------------------------

Does anybody know if the problem lies with class
"com.iseriesnetwork.clubtech.xlparse.ParseSheet" 
Or with XLPARSER4? Any help would be appreciated.

Thanks,
Karl B. Woods  
Sr. Programmer/Analyst
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------