Re: Scott's Excel stuff and Giovanni's XLPARSE2

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Please remove any poi-related or xlparse-related objects from 
/QIBM/UserData/Java400/ext.  I don't know why you think *I* recommended 
that -- but I don't recommend it.  It's a bad practice.

The only time I suggested using that directory was back in 2004 when 
folks had trouble because CLASSPATH was ignored by RPG starting Java. 
This was fixed a _long_ time ago.

At any rate, you'll have this sort of problem until you remove the old 
copies from /QIBM/UserData/Java400/ext


On 3/22/2010 10:30 AM, Jack Tucky wrote:
> A few months ago I installed Scott’s excel POI stuff and got it working.  I
> installed the Java classes where Scott recommended
> (/QIBM/UserData/Java400/ext) and everything works great.
>
> Just recently I downloaded Giovanni’s XLPARSE2 code as well.  I can’t get
> Giovanni’s code to work.  I get an error when it starts to use Java to read
> the Excel file.  Giovanni was answering emails immediately on Friday night
> (awesome!) and he finally suggested I test Scott’s program in XLPARSE2.
> It’s having the same problem.
>
>
> This call to Scott's test program ends with an error:
>
> call xlparse2/xlpdemo
>
> DSPLY  Error occcured while parsing spreadsheet.
>
>
> When I run Giovanni’s test, I get this.  I believe this is the same basic
> problem.
>
> Message . . . . :   Java exception received when calling Java
> method.
>   Cause . . . . . :   RPG procedure XLPARSE_WO in program
> XLPARSE2/XLPARSER4
>     received Java exception "java.lang.NoSuchMethodError: getType ()I"
> when
>     calling method "parse201003" with signature "([B)V" in class
>
>
> "com.iseriesnetwork.clubtech.xlparse.ParseSheet".
>
>
>
> Giovanni says that his code isn't finding the Java class.  We've checked the
> install of the JAR's in the IFS, the classpath is set properly, and
> everything else we could think of.
>
> Any help appreciated.  Thanks, Jack