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 <cbamf...@mimecast.com<mailto:cbamf...@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 <apa...@gagravarr.org<mailto:apa...@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-unsubscr...@poi.apache.org<mailto:user-unsubscr...@poi.apache.org> For additional commands, e-mail: user-h...@poi.apache.org<mailto:user-h...@poi.apache.org>
