Just installed Spreadsheet::ParseExcel
module, but got problem. See a few related question, but not exact the same.
#!/usr/bin/perl -w
use strict;
use warnings;
use Spreadsheet::ParseExcel;
use Data::Dumper;
my $bill = $ARGV[0] || die "Usage: $0 bill.xlsx\n";
my $parser = Spreadsheet::ParseExcel->new();
my $workbook = $parser->parse('Book2.xlsx');
print Dumper $workbook;
for my $worksheet ( $workbook->worksheet() ) { }
When I run the perl script, I got following error:
Can't call method "worksheet" on an undefined value at read.bill.xlsx.pl line 15.
So I dumped $workbook
, and got:
$VAR1 = undef;
and dumper parser shows some data. This means $parser->parse
failed. Anybody know why? Thanks.