Spreadsheet-ParseExcel is unable to parse excel 2007 file

CPAN::Forum

Thread

Spreadsheet-ParseExcel [search.cpan.org] [Kobes search] [View and report bugs] [Ratings 4.7

(7) ]

[AnnoCPAN] [CPAN Tests results] [CPANTS]

Posted on Thu Sep 6 15:02:40 2007 by dkn210098

Spreadsheet-ParseExcel is unable to parse excel 2007 file

I am trying to parse excel 2007 file using Spreadsheet-ParseExcel module but not able to parse

my $excel = Spreadsheet::ParseExcel::Workbook->Parse($fname);

here I am able to get the object of Spreadsheet::ParseExcel::Workbook

@{$excel->{Worksheet}}

doesen't returning any worksheet while actual excel file contains a worksheet. can anyone tell me what is the issue and how I can resolve it.

Direct Responses: 6027 | Write a response

Posted on Thu Sep 6 17:56:48 2007 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.
--

Write a response

Service launched on 2nd of February 2005.
Comments, and other submissions on CPAN Forum are Copyright 2005-2007, their respective owners.
Site maintainer is not responsible for content. Privacy Policy

Maintained and hosted by Gabor Szabo at Perl Training Israel