Bug 54506 - Inconsistent handling of excel from email source
Summary: Inconsistent handling of excel from email source
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-31 07:51 UTC by wcasey
Modified: 2013-02-07 21:54 UTC (History)
0 users



Attachments
Outlook email message with excel attachment that hssf wont open (5.50 KB, application/vnd.ms-excel)
2013-01-31 07:51 UTC, wcasey
Details

Note You need to log in before you can comment on or make changes to this bug.
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...