Spreadsheet-ParseExcel - Re: Spreadsheet-ParseExcel is unable to parse excel 2007 file

Posted on Thu Sep 6 17:56:48 2007 by jmcnamara in response to 6026 (See the whole thread of 2)
Re: Spreadsheet-ParseExcel is unable to parse excel 2007 file

Spreadsheet::ParseExcel only handles the Excel binary files format called Biff that is used in Excel versions prior to 2007. Excel 2007 has a new file format that is comprised of zipped XML files. This is not handled by Spreadsheet::WriteExcel.

If you unzip the 2007 xls file (change the extension to .zip if necessary) you can probably parse the information out of the embedded XML files using one of the Perl XML parsers.

John.
--
Write a response