× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I have installed the latest verson of the POS API's and the latest version of the XLPARSER4 service program.
The demo program ran without any problems.

When I modified it for my application, I received the following error:
                         Additional Message Information                        
                                                                               
 Message ID . . . . . . :   RNX0301                                            
 Date sent  . . . . . . :   10/16/08      Time sent  . . . . . . :   16:23:23  
                                                                               
 Message . . . . :   Java exception received when calling Java method.         
                                                                               
 Cause . . . . . :   RPG procedure XLPARSE_WO in program QGPL/XLPARSER4        
   received Java exception "java.io.FileNotFoundException: no such entry:      
   "Workbook"" 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').                 
 
The statement in my program is :
If XlParse_WorkBook( '/excel/vaijy/paid.xls'        
                   : %paddr(NumberCell)             
                   : %paddr(CharCell)  ) < 0;       

When I check the IFS using wrklnk '/excel/vaijy/paid.xls' , I get
                                                                              
 Directory  . . . . :   /excel/vaijy                                          
                                                                              
 Type options, press Enter.                                                   
   2=Edit   3=Copy   4=Remove   5=Display   7=Rename   8=Display attributes   
   11=Change current directory ...                                            
                                                                              
 Opt   Object link            Type     Attribute    Text                      
       paid.xls               STMF                                            
                                                                              
                                                                              
Since the file is present and the name is correct, what am I doing wrong?

TIA,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.