RE: Excel Spreadsheets

["Karl Woods" <Karl.Woods@xxxxxxxxxxxxxx>]

Where would I find an updated version of xlparse.jar? I've looked on the
poi website and could not find any mention of xlparse


-----Original Message-----
From: Scott Klement [mailto:sk@xxxxxxxxxxxxxxxx] 
Sent: Wednesday, April 29, 2009 12:43 AM
To: HTTPAPI and FTPAPI Projects
Subject: Re: Excel Spreadsheets

This means that you have a mismatch between xlparse.jar & the POI jar 
files.  POI broke compatibility when they switched from version 2.x to 
3.x.  To solve the problem, you need to make sure you have the right 
version of xlparse.jar for the version of POI you're using.


Karl Woods wrote:
> 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
>
-----------------------------------------------------------------------
> 
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------