More XLPARSE problems

Hi group,

I have just managed to get the XLPDEMO program running.  Apparently you 
need to add the classpath variable in the program, probably has something 
to do with the activation group (?).

Anyway, I have now modified this program so that it reads and processes 
one of my own spreadsheets, and everything works just fine, until it 
reaches the end of the data.

After that, I get the following Java errors:

                         Additional Message Information  
  
 Message ID . . . . . . :   RNX0301       Severity . . . . . . . :   50   
 Message type . . . . . :   Escape  
 Date sent  . . . . . . :   14/07/05      Time sent  . . . . . . : 
15:03:39 
  
 Message . . . . :   Java exception received when calling Java method.  
 Cause . . . . . :   RPG procedure XLPARSE_WO in program 
COLPAERP/XLPARSER4 
   received Java exception 
"org.apache.poi.hssf.record.RecordFormatException: 
   Unable to construct record instance, the following" 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.  


                         Additional Message Information  
  
 Message ID . . . . . . :   RNX0301       Severity . . . . . . . :   50   
 Message type . . . . . :   Escape  
 Date sent  . . . . . . :   14/07/05      Time sent  . . . . . . : 
15:04:39 
  
 Message . . . . :   Java exception received when calling Java method.  
 Cause . . . . . :   RPG procedure XLPARSE_WO in program 
COLPAERP/XLPARSER4 
   received Java exception "java.lang.NullPointerException:" 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.  

Is there any way to tell the program to stop parsing at a certain point? 
Or does the excel sheet have to comply with certain requirements to signal 
an 'end-of-file' for the parser?

Thanks in advance,

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----