RE: hssf upload file issue

[Narasimhan, Shyamala]

Also I get this error at times

java.lang.ArrayIndexOutOfBoundsException
        at org.apache.poi.util.LittleEndian.getNumber(LittleEndian.java:557)
        at org.apache.poi.util.LittleEndian.getUShort(LittleEndian.java:102)
        at
org.apache.poi.hssf.record.SSTDeserializer.manufactureStrings(SSTDeserialize
r.java:129)
        at
org.apache.poi.hssf.record.SSTDeserializer.readStringRemainder(SSTDes
erializer.java:359)
        at
org.apache.poi.hssf.record.SSTDeserializer.processContinueRecord(SSTD
eserializer.java:320)
        at
org.apache.poi.hssf.record.SSTRecord.processContinueRecord(SSTRecord.
java:539)
        at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.
java:218)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1
91)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1
58)

-----Original Message-----
From: Narasimhan, Shyamala [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 15, 2003 2:07 PM
To: '[EMAIL PROTECTED]'
Subject: hssf upload file issue

Hi

I am trying to convert (to hssf) an xls file uploaded through struts on a
weblogic server.. the file gets converted if I use a standalone java
application but fails when uploaded through the web. The file contains more
than 2000 rows. This is the code that converts the file

 

      // get the file from form

        FormFile prodFile = uploadForm.getFile();

        String fileName = prodFile.getFileName();

        log__.info("file name = " + fileName + "... fileSize = " +
prodFile.getFileSize());

        POIFSFileSystem fs = new POIFSFileSystem(prodFile.getInputStream());

 

        HSSFWorkbook wb = null;

        try {

          wb = new HSSFWorkbook(fs);

        }

        catch (Exception e){

          e.printStackTrace();

        }

 

This is the error that I am getting

java.lang.NegativeArraySizeException

        at
org.apache.poi.hssf.record.SSTDeserializer.readStringRemainder(SSTDes

erializer.java:335)

        at
org.apache.poi.hssf.record.SSTDeserializer.processContinueRecord(SSTD

eserializer.java:320)

        at
org.apache.poi.hssf.record.SSTRecord.processContinueRecord(SSTRecord.

java:539)

        at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.

java:218)

        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1

91)

        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1

58)

        at
com.om.client.ui.struts.action.pmf.supplierfeed.UploadProductListActi

on.perform(UploadProductListAction.java:102)

 

can anybody pls help.

Thanks

Shyamala.