Perl Spreadsheet::ParseExcel cannot parse and return undef

Question

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.

from the docs of Spreadsheet::ParseExcel. The module cannot read files in the Excel 2007 Open XML XLSX format. See the Spreadsheet::XLSX module instead. — clt60
– clt60, Commented Sep 25, 2014 at 7:53

mpapec · Accepted Answer · 2014-09-25 06:54:41Z

2

As documentation suggest, you have to test if parse() returned undef and check error message,

my $workbook = $parser->parse('Book2.xlsx') // die $parser->error();

answered Sep 25, 2014 at 6:54

mpapec

50.7k8 gold badges71 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tony Xu Over a year ago

Thanks for that and I got: No Excel data found. However, it confirms problem is $parser->parse.

Praveen · Accepted Answer · 2014-09-25 07:09:47Z

2

Try this:

#!/usr/bin/perl -w

use strict;
use Spreadsheet::ParseExcel;

my $bill = $ARGV[0] || die "Usage: $0 bill.xlsx\n";
my $parser   = Spreadsheet::ParseExcel->new();
my $workbook = $parser->parse('Book2.xls');

if ( !defined $workbook ) {
    die $parser->error(), ".\n";
}

for my $worksheet ( $workbook->worksheets() ) {

}

answered Sep 25, 2014 at 7:09

Praveen

9026 silver badges22 bronze badges

Comments

Tony Xu · Accepted Answer · 2014-09-25 07:51:03Z

2

After googling around, I found XLSX format requires Spreadsheet::XLSC instead of ParseExcel. Also the parse function take the filename then no need the step of $parser->parse.

answered Sep 25, 2014 at 7:51

Tony Xu

3,1014 gold badges34 silver badges47 bronze badges

Collectives™ on Stack Overflow

Perl Spreadsheet::ParseExcel cannot parse and return undef

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related