On Wed, 6 Aug 2014, Walter Rice wrote:
I had a piece of code working fine that converted an excel sheet to csv (file extension is csv but underlying content type "application/vnd.ms-excel";/). This worked fine when the CSV file was generated on old Excel (pre 2010), but no matter what I do in windows 7/office 2010 the contenttype is always excel -- even if I use other applications to generate the CSV!
Apache POI does not read CSV files, only the binary .xls and the zip-of-xml based .xlsx files.
You need to make sure you input was properly saved as one of those two. Simply saving as a csv then renaming to .xls may be enough to fool Excel, but POI still knows the difference...
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
