You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Chris Bamford <cb...@mimecast.com> on 2014/09/08 13:28:54 UTC
Re: POI RecordFormatException when reading XLS file
Hi Nick
Just picked this up again. I have had a go with BiffViewer and it tells me that the offending record is the first instance of record type ExtSSTRecord, immediately after the SST table.
The SST table all dumps correctly and visually matches the data in Excel.
At this point I don’t know how to proceed as the exception is thrown (blow) and I don’t know how to interpret the values in the debugger.
Can you guide me? I have permission to make the xls file public if that would help. I could also send the output of BiffViewer and POIFSViewer ..
Exception message:
org.apache.poi.hssf.record.RecordFormatException: Not enough data (0) to read requested (2) bytes
Thanks,
- Chris
Chris Bamford
Senior Developer
m: +44 7860 405292
p: +44 207 847 8700
w: www.mimecast.com
Address click here: www.mimecast.com/About-us/Contact-us/
On 4 Aug 2014, at 10:24, Nick Burch <ap...@gagravarr.org>> wrote:
On Mon, 4 Aug 2014, Chris Bamford wrote:
Good idea. I ran the validator on the els file and it fails. Not sure I understand all the details, though! Here’s the output:
<BFFValidation path="z:\Downloads\file.xls" datetime="08/01/14 16:58:33" result="FAILED">
This is the main bit - result=FAILED. Your file isn't a valid Excel file, based on the spec
If Excel loads the file, then it probably isn't that far off. With the file, we might be able to add a suitable workaround too. Without it, you'll need to do that, and submit a patch! Start by identifying the problem record (maybe with BiffViewer), then look at the hex dump of the stream (POIFSViewer) and compare that with the file format docs ([MS-XLS].pdf) to see where it differs
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org<ma...@poi.apache.org>
For additional commands, e-mail: user-help@poi.apache.org<ma...@poi.apache.org>
Re: POI RecordFormatException when reading XLS file
Posted by Chris Bamford <cb...@mimecast.com>.
Nick
If you like I could create a Jira case and attach the file - would you prefer that?
Thanks
- Chris
Chris Bamford
Senior Developer
m: +44 7860 405292
p: +44 207 847 8700
w: www.mimecast.com
Address click here: www.mimecast.com/About-us/Contact-us/
On 8 Sep 2014, at 12:28, Chris Bamford <cb...@mimecast.com>> wrote:
Hi Nick
Just picked this up again. I have had a go with BiffViewer and it tells me that the offending record is the first instance of record type ExtSSTRecord, immediately after the SST table.
The SST table all dumps correctly and visually matches the data in Excel.
At this point I don’t know how to proceed as the exception is thrown (blow) and I don’t know how to interpret the values in the debugger.
Can you guide me? I have permission to make the xls file public if that would help. I could also send the output of BiffViewer and POIFSViewer ..
Exception message:
org.apache.poi.hssf.record.RecordFormatException: Not enough data (0) to read requested (2) bytes
Thanks,
- Chris
On 4 Aug 2014, at 10:24, Nick Burch <ap...@gagravarr.org>> wrote:
On Mon, 4 Aug 2014, Chris Bamford wrote:
Good idea. I ran the validator on the els file and it fails. Not sure I understand all the details, though! Here’s the output:
<BFFValidation path="z:\Downloads\file.xls" datetime="08/01/14 16:58:33" result="FAILED">
This is the main bit - result=FAILED. Your file isn't a valid Excel file, based on the spec
If Excel loads the file, then it probably isn't that far off. With the file, we might be able to add a suitable workaround too. Without it, you'll need to do that, and submit a patch! Start by identifying the problem record (maybe with BiffViewer), then look at the hex dump of the stream (POIFSViewer) and compare that with the file format docs ([MS-XLS].pdf) to see where it differs
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org<ma...@poi.apache.org>
For additional commands, e-mail: user-help@poi.apache.org<ma...@poi.apache.org>