in reply to Parsing Excel Workbook

I've never used it (though I anticipate doing so soon), but it appears that Spreadsheet::ParseExcel is capable of doing that. It seems a bit complex, so perhaps if you're new to Perl Spreadsheet::ParseExcel::Simple may be a better choice. Ask me in a week or so what I think of them, as I'll be starting a project that may involve their use. If you're not familiar with how to install modules from CPAN, there is a nice FAQ on CPAN's main site, and a PerlMonks Tutorial here.

Replies are listed 'Best First'.
Re: Re: Parsing Excel Workbook
by geekgrrl (Pilgrim) on May 26, 2004 at 20:05 UTC
    I love Spreadsheet::ParseExcel::Simple. Its incredibly easy to use, and I think the interface is much more intuitive and obvious that that of Spreadsheet::ParseExcel. here's a snippet of code that I use: 
        
my $xls = Spreadsheet::ParseExcel::Simple->read($excel); #$excel is a 
+filehandle.
warn "read Excel spreadsheet";
#warn Dumper $xls;
my @data;
    foreach my $sheet ($xls->sheets) {
         while ($sheet->has_data) {
              push @row, $sheet->next_row;
         } 
     }

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom