POI not parsing these XLS file

2016-04-21 Thread Andrew Munn
I am using poi 3.15 I can not get POI to parse these XLS files being generated by Bloomberg into something useful. I can use Tika to parse them into one long line of HTML but then there are no cell breaks or line breaks. http://www.topazdevelopment.com/tmp/poi/2010-cal-eu.xls Tika indentifie

Re: POI not parsing these XLS file

2016-04-21 Thread Nick Burch
On Thu, 21 Apr 2016, Andrew Munn wrote: I can not get POI to parse these XLS files being generated by Bloomberg into something useful. I can use Tika to parse them into one long line of HTML but then there are no cell breaks or line breaks. http://www.topazdevelopment.com/tmp/poi/2010-cal-eu.xl

Re: POI not parsing these XLS file

2016-04-21 Thread Javen O'Neal
Interesting. Xls extension identified as application/xml. POI does not support the Workbook XML format. OOXML is different. On Apr 21, 2016 8:37 AM, "Andrew Munn" wrote: > I am using poi 3.15 > > I can not get POI to parse these XLS files being generated by Bloomberg > into something useful. I c

Re: POI not parsing these XLS file

2016-04-21 Thread Andrew Munn
Looks like Gnumeric ssconvert likes it: ssconvert -E Gnumeric_Excel:excel 2010-cal-eu.xls -T Gnumeric_stf:stf_csv /tmp/1.csv -Andrew On Thu, 21 Apr 2016, Javen O'Neal wrote: > Interesting. Xls extension identified as application/xml. POI does not > support the Workbook XML format. OOXML is d

RE: POI not parsing these XLS file

2016-04-21 Thread Allison, Timothy B.
: Thursday, April 21, 2016 11:43 AM To: POI Users List Subject: Re: POI not parsing these XLS file Interesting. Xls extension identified as application/xml. POI does not support the Workbook XML format. OOXML is different. On Apr 21, 2016 8:37 AM, "Andrew Munn" wrote: > I am using