You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Pruitt, Byron S" <st...@hp.com> on 2010/11/15 21:52:44 UTC
cannot exceed 8224 bytes
I am getting the org.apache.poi.hssf.record.RecordFormatException: The content of an excel record cannot exceed 8224 bytes exception. I searched and found several references to it. Was this fixed in 3.5 as some people have indicated. I am running with 3.7 beta.
-S
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: cannot exceed 8224 bytes
Posted by "Pruitt, Byron S" <st...@hp.com>.
Yes, I can and yes, I will. I want to try something prior and I want to do a quick trial with HSSFWork as you suggest.
-S
-----Original Message-----
From: Nick Burch [mailto:nick.burch@alfresco.com]
Sent: Monday, November 15, 2010 4:33 PM
To: POI Users List
Subject: RE: cannot exceed 8224 bytes
On Mon, 15 Nov 2010, Pruitt, Byron S wrote:
> The spreadsheet is very small. 1 Sheet, about 15 columns, about 15
> rows. Most text.
Are you able to share the contents of the file? If so, please create a new
bug in bugzilla and upload it.
Also, since you're using the eventusermodel, it's worth trying it quickly
with the regular UserModel code (HSSFWorkbook). I wouldn't expect any
differences, since they largely use the same record code underneath, but
it's worth a check all the same
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: cannot exceed 8224 bytes
Posted by Nick Burch <ni...@alfresco.com>.
On Mon, 15 Nov 2010, Pruitt, Byron S wrote:
> The spreadsheet is very small. 1 Sheet, about 15 columns, about 15
> rows. Most text.
Are you able to share the contents of the file? If so, please create a new
bug in bugzilla and upload it.
Also, since you're using the eventusermodel, it's worth trying it quickly
with the regular UserModel code (HSSFWorkbook). I wouldn't expect any
differences, since they largely use the same record code underneath, but
it's worth a check all the same
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: cannot exceed 8224 bytes
Posted by "Pruitt, Byron S" <st...@hp.com>.
Sorry, I didn't provide much information. I hit send to soon. :>)
I am not sure what record is triggering. I have the 3.7 beta, I didn't know the 3.7 final was out. I will grab it.
I am posting my xls to the server. I verified the bytes arrive ok, by immediately writing them out to a temp file. Excel can open this file ok.
The spreadsheet is very small. 1 Sheet, about 15 columns, about 15 rows. Most text.
On the server, I do..
ByteArrayInputStream bais = new ByteArrayInputStream(decoded); // decoded is the xls.
MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
formatListener = new FormatTrackingHSSFListener(listener);
HSSFEventFactory factory = new HSSFEventFactory();
HSSFRequest request = new HSSFRequest();
workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
request.addListenerForAllRecords(workbookBuildingListener);
factory.processEvents(request, dis);
And, I get
org.apache.poi.hssf.record.RecordFormatException: The content of an excel record cannot exceed 8224 bytes
at org.apache.poi.hssf.record.RecordInputStream.nextRecord(RecordInputStream.java:200)
at org.apache.poi.hssf.record.RecordFactoryInputStream$StreamEncryptionInfo.<init>(RecordFactoryInputStream.java:53)
at org.apache.poi.hssf.record.RecordFactoryInputStream.<init>(RecordFactoryInputStream.java:167)
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:139)
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:106)
Thanks for any help.
-S
-----Original Message-----
From: Nick Burch [mailto:nick.burch@alfresco.com]
Sent: Monday, November 15, 2010 4:00 PM
To: POI Users List
Subject: Re: cannot exceed 8224 bytes
On Mon, 15 Nov 2010, Pruitt, Byron S wrote:
> I am getting the org.apache.poi.hssf.record.RecordFormatException: The
> content of an excel record cannot exceed 8224 bytes exception.
What record is this for, and what are you doing to trigger it?
> Was this fixed in 3.5 as some people have indicated. I am running with
> 3.7 beta.
Generally all the records that can be continued to extend past the 8224
byte barrier already have support in for that, but occasionally we
discover one that can be large but we didn't know that. If you're hitting
it with 3.7 final, then you'll almost certainly need to open a bug report
and describe what record you're hitting it on, and how to trigger it
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: cannot exceed 8224 bytes
Posted by Nick Burch <ni...@alfresco.com>.
On Mon, 15 Nov 2010, Pruitt, Byron S wrote:
> I am getting the org.apache.poi.hssf.record.RecordFormatException: The
> content of an excel record cannot exceed 8224 bytes exception.
What record is this for, and what are you doing to trigger it?
> Was this fixed in 3.5 as some people have indicated. I am running with
> 3.7 beta.
Generally all the records that can be continued to extend past the 8224
byte barrier already have support in for that, but occasionally we
discover one that can be large but we didn't know that. If you're hitting
it with 3.7 final, then you'll almost certainly need to open a bug report
and describe what record you're hitting it on, and how to trigger it
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org