Re: More XLPARSE problems -- RPG400-L

If CLASSPATH is stored at job level (which is what I thought), then how
come the program gives a 'Class not found' or similar error if I add the
variable from the command line before running the program interactively,
but does find the class if the classpath is setup using a system() call
within the program?

I don't know? On my system, it works just fine when the variable is setprior to calling the program.

Wait... you aren't calling the program through QShell, are you? That wouldmake it behave differntly. Just call it with the CALL command.

Why are you using system() to set the variable? Why not use putenv()?How are you starting the JVM?

"The excel record that HSSF is not familiar with" always appears to be the
record below the last relevant row in my sheet.  Strangely enough, if I
create a sheet that has twice the number of rows, it's again the row
following the last "filled in" one.

I've never encountered the error, I'm just guessing that it means thatit's a record type that HSSF doesn't understand. Please note that anExcel record is not the same as "one row of cells".

As for stopping the parsing, do I understand correctly that I can simply
have the subprocedure return *ON if it encounters a "blank" line?  For
instance, if column 0 is always filled in as character, have the charcell
procedure return *ON if Value is *blanks?

Returning *ON will end the parsing, but I don't know how to detect thatyou're at the end of the spreadsheet. If Excel always writes the cells sothat the blank ones come after the zero ones, then yes, your method shouldwork.

Unfortunately, I haven't experimented with it, so you'll have toexperiment and see what works.