I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Spreadsheet-ParseExcel
Posted on 2007-09-06 14:56:48-07 by jmcnamara in response to 6026
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.
--
Direct Responses: Write a response