|Summary:||Inconsistent handling of excel from email source|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|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...