Error on open workbook after removal sheet(s)

Last post 04-25-2007, 9:44 AM by HGOAS4. 6 replies.
Sort Posts: Previous Next
  •  04-20-2007, 5:14 AM 73825

    Error on open workbook after removal sheet(s)

    Hello,

    I'm having problems when re-opening a workbook after I've removed a sheet !

    [error]                                                                               
     Cause . . . . . :   RPG procedure ACELLOPENW in program AAITMRMP1/ACELLSRV    
       received Java exception "java.lang.IllegalArgumentException: Invalid sheet  
       index: -1" when calling method "open" with signature "(Ljava.lang.String;)V"
       in class "com.aspose.cells.Workbook".                                       

    [/error]

    Is this a known problem ?

    Kind regards,

    Goddeau H.


    Hendrik Goddeau
    Freelance consultant iSeries
    www.goddeauconsulting.be
     
  •  04-22-2007, 11:20 PM 73970 in reply to 73825

    Re: Error on open workbook after removal sheet(s)

    Hi,

    Could you attach your created file and simple project ? It will help us to fix it.


    Warren Zhang
    Developer
    Aspose Nanjing Team
    About Us
    Contact Us
     
  •  04-23-2007, 2:15 AM 73986 in reply to 73970

    Re: Error on open workbook after removal sheet(s)

    Attachment: Present (inaccessible)
    Error on open of this workbook !
    Hendrik Goddeau
    Freelance consultant iSeries
    www.goddeauconsulting.be
     
  •  04-23-2007, 9:32 PM 74101 in reply to 73825

    Re: Error on open workbook after removal sheet(s)

    Attachment: Present (inaccessible)

    Hi,

    Please try this fix.


    Warren Zhang
    Developer
    Aspose Nanjing Team
    About Us
    Contact Us
     
  •  04-24-2007, 4:20 AM 74138 in reply to 74101

    Re: Error on open workbook after removal sheet(s)

    Hello Warren,

    Thanks for your reply.

    When trying the fix, I receive this message :

    Message . . . . :   Java exception received when calling Java method.                
    Cause . . . . . :   RPG procedure ACELLOPENW in program AAITMRMP1/ACELLSRV           
      received Java exception "java.lang.UnsupportedClassVersionError:                   
      com/aspose/cells/Workbook" when calling method "<init>" with signature "()V"       
      in class "com.aspose.cells.Workbook". 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').                

    We user JDK4.0 on iseries.

    Kind regards,

    Goddeau H.


    Hendrik Goddeau
    Freelance consultant iSeries
    www.goddeauconsulting.be
     
  •  04-24-2007, 7:56 PM 74287 in reply to 73825

    Re: Error on open workbook after removal sheet(s)

    Attachment: Present (inaccessible)

    Hi,

    Please try this fix for JDK1.4.


    Warren Zhang
    Developer
    Aspose Nanjing Team
    About Us
    Contact Us
     
  •  04-25-2007, 9:44 AM 74371 in reply to 74287

    Re: Error on open workbook after removal sheet(s)

    Seems to work.

    I'll have to test it properly.

    Thanks a lot,

    Hendrik Goddeau


    Hendrik Goddeau
    Freelance consultant iSeries
    www.goddeauconsulting.be
     
View as RSS news feed in XML