You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "Height, Jason" <jh...@subcorp.com.au> on 2003/11/03 22:06:05 UTC
RE: unable to open HSSF (generated) excel file
Since RC1 is now out. Could you give that a go. There are a large number of
corruption issues that were sorted out in this release over and above pre3.
Jason
-----Original Message-----
From: Tom [mailto:dist_mec@hotmail.com]
Sent: Friday, 31 October 2003 10:23 AM
To: Tom; poi-dev@jakarta.apache.org
Subject: Re: unable to open HSSF (generated) excel file
using poi-bin-2.0-pre3-20030728
platforms- win2k and solaris.
our application queries a DB user-log table and generates a workbook sheet
that contains 3 columns (plus some header columns). the 3 columns are
"username" "login-time" and "logout-time" all cell values are writted out as
strings. in some cases the workbook generated will not open in MS-Excel
2000. i wrote a test pgm that can recreate the problem consistently, using
the the data from the DB exported into a flat file. the test pgm simply
reads the file and writes to a workbook.
i have noticed that this seems to depend on size. if i run this for records
for the current month only, the report is generated correctly. if i run it
for the whole year, i am unable to open the file.
i noticed a similar thread in the list and as per the resolution note, i
checked out the latest code from CVS today morning and tried re-running the
test pgm with the latest jars but i get the following exception
java.lang.ArrayIndexOutOfBoundsException
at org.apache.poi.util.LittleEndian.putNumber(LittleEndian.java:549)
at org.apache.poi.util.LittleEndian.putShort(LittleEndian.java:282)
at org.apache.poi.hssf.record.RowRecord.serialize(RowRecord.java:465)
at
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.serializeRowBlock(
RowRecordsAggregate.java:244)
at
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.serialize(RowRecor
dsAggregate.java:275)
at org.apache.poi.hssf.model.Sheet.serialize(Sheet.java:734)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:787)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:731)
at src.ReadWriteWorkbook.main(ReadWriteWorkbook.java:61)
Exception in thread "main"
i can send out the test pgm (which is fairly straight forward) and the input
test file (cannot attach it as the zipped file size is abt 150k). can
someone please help me with the problem?
note - if i try ms-excel 2002, i am able to open the file but i get an
error dialog saying "errors detected in workbook, but ms excel was able to
open it by making repairs listed below" the repair log says that the repairs
were not possible.
please let me know if i should open this as a bug or i should pose this to
some other mailing list.
thanks,
--------------------------------------------------------------------------------------------------------------------
This e-mail (including attachments) is confidential information of Australian Submarine Corporation Pty Limited (ASC). It may also be legally privileged. Unauthorised use and disclosure is prohibited. ASC is not taken to have waived confidentiality or privilege if this e-mail was sent to you in error. If you have received it in error, please notify the sender promptly. While ASC takes steps to identify and eliminate viruses, it cannot confirm that this e-mail is free from them. You should scan this e-mail for viruses before it is used. The statements in this e-mail are those of the sender only, unless specifically stated to be those of ASC by someone with authority to do so.
Re: unable to open HSSF (generated) excel file
Posted by Tom <di...@hotmail.com>.
i tried the RC1 release yesterday and the problem has been solved. i will
test some more cases.
thanks.
----- Original Message -----
From: "Height, Jason" <jh...@subcorp.com.au>
To: "'POI Developers List'" <po...@jakarta.apache.org>
Sent: Monday, November 03, 2003 1:06 PM
Subject: RE: unable to open HSSF (generated) excel file
> Since RC1 is now out. Could you give that a go. There are a large number
of
> corruption issues that were sorted out in this release over and above
pre3.
>
> Jason
>
> -----Original Message-----
> From: Tom [mailto:dist_mec@hotmail.com]
> Sent: Friday, 31 October 2003 10:23 AM
> To: Tom; poi-dev@jakarta.apache.org
> Subject: Re: unable to open HSSF (generated) excel file
>
> using poi-bin-2.0-pre3-20030728
> platforms- win2k and solaris.
>
> our application queries a DB user-log table and generates a workbook
sheet
> that contains 3 columns (plus some header columns). the 3 columns are
> "username" "login-time" and "logout-time" all cell values are writted out
as
> strings. in some cases the workbook generated will not open in MS-Excel
> 2000. i wrote a test pgm that can recreate the problem consistently, using
> the the data from the DB exported into a flat file. the test pgm simply
> reads the file and writes to a workbook.
>
> i have noticed that this seems to depend on size. if i run this for
records
> for the current month only, the report is generated correctly. if i run it
> for the whole year, i am unable to open the file.
>
> i noticed a similar thread in the list and as per the resolution note, i
> checked out the latest code from CVS today morning and tried re-running
the
> test pgm with the latest jars but i get the following exception
> java.lang.ArrayIndexOutOfBoundsException
> at org.apache.poi.util.LittleEndian.putNumber(LittleEndian.java:549)
> at org.apache.poi.util.LittleEndian.putShort(LittleEndian.java:282)
> at org.apache.poi.hssf.record.RowRecord.serialize(RowRecord.java:465)
> at
>
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.serializeRowBlock(
> RowRecordsAggregate.java:244)
> at
>
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.serialize(RowRecor
> dsAggregate.java:275)
> at org.apache.poi.hssf.model.Sheet.serialize(Sheet.java:734)
> at
> org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:787)
> at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:731)
> at src.ReadWriteWorkbook.main(ReadWriteWorkbook.java:61)
> Exception in thread "main"
>
> i can send out the test pgm (which is fairly straight forward) and the
input
> test file (cannot attach it as the zipped file size is abt 150k). can
> someone please help me with the problem?
>
> note - if i try ms-excel 2002, i am able to open the file but i get an
> error dialog saying "errors detected in workbook, but ms excel was able to
> open it by making repairs listed below" the repair log says that the
repairs
> were not possible.
>
> please let me know if i should open this as a bug or i should pose this to
> some other mailing list.
>
>
> thanks,
> --------------------------------------------------------------------------
------------------------------------------
> This e-mail (including attachments) is confidential information of
Australian Submarine Corporation Pty Limited (ASC). It may also be legally
privileged. Unauthorised use and disclosure is prohibited. ASC is not
taken to have waived confidentiality or privilege if this e-mail was sent to
you in error. If you have received it in error, please notify the sender
promptly. While ASC takes steps to identify and eliminate viruses, it
cannot confirm that this e-mail is free from them. You should scan this
e-mail for viruses before it is used. The statements in this e-mail are
those of the sender only, unless specifically stated to be those of ASC by
someone with authority to do so.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org