Bug 54506

Summary: Inconsistent handling of excel from email source
Product: POI Reporter: wcasey
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Outlook email message with excel attachment that hssf wont open

Description wcasey 2013-01-31 07:51:27 UTC
Created attachment 29908 [details]
Outlook email message with excel attachment that hssf wont open

I receive an email with an xls attachment that I cant parse when it 
comes straight from the sender system. 

If I save the attachment to my local drive and then parse it, everything works as expected.

I can send the original email if the attachment gets parsed without any issues

thanks
Will
Comment 1 Nick Burch 2013-02-07 21:54:01 UTC
I don't know whether it's Outlook / Exchange doing something very odd to the file in transport, or if it's just a bizarre file to start with and saving it out gets it fixed.

One thing that makes me think the latter is the references to "Crystal Reports" in the file. That is well known for producing "interesting" excel files...

The file only has a BOOK entry (not Workbook), and no properties/metadata. However, when I add an exception for BOOK much as we already have for WORKBOOK, all seems fine.

So, I've updated the naughty list to include BOOK in r1443745, and it seems to just work...