DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12561>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12561

HSSFWorkbook throws Exceptions

           Summary: HSSFWorkbook throws Exceptions
           Product: POI
           Version: 1.5.1
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: Minor
          Priority: Other
         Component: HSSF
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I wrote a following code to read xls file that is created by
Japanese MS-Excel 2000.

public class Test {
  public static void main ( String[] args ) 
                throws IOException {
    if ( args.length != 1 ) {
      System.err.println ( "Usage: java Test xls_file" );
      System.exit ( 0 );
    }
    FileInputStream fi = new FileInputStream ( args[1] );
    HSSFWorkbook wb = new HSSFWorkbook ( fi );
    fi.close ( );
  }
}

It's almost O.K.
But, reading some xls file, HSSFWorkbook throws following exceptions.

1) Exception in thread "main" java.lang.NullPointerException
        at org.apache.poi.hssf.record.SSTRecord.getString(SSTRecord.java:309)
        at org.apache.poi.hssf.model.Workbook.getSSTString(Workbook.java:576)
        at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:305)
        at org.apache.poi.hssf.usermodel.HSSFRow.createCellFromRecord(HSSFRow.java:233)
        at
org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet(HSSFSheet.java:171)
        at org.apache.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:134)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:154)


2) Exception in thread "main" java.lang.NegativeArraySizeException
        at
org.apache.poi.hssf.record.SSTDeserializer.readStringRemainder(SSTDeserializer.java:335)
        at
org.apache.poi.hssf.record.SSTDeserializer.processContinueRecord(SSTDeserializer.java:320)
        at
org.apache.poi.hssf.record.SSTRecord.processContinueRecord(SSTRecord.java:540)
        at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:210)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:140)

regards.

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to