CODEWITHSUNDEEP
perlexcelspreadsheet
patseb
patseb

Reputation: 651

Perl can't locate function, but packet was installed

I'm using Spreadsheet::WriteExcel packet to create some Excel files. Everything works fine but when I'm trying to set up column width using:

$excel->set_column("A:F",  20);

were excel is:

my $excel = Spreadsheet::WriteExcel->new('test.xls');

I got error:

Can't locate object method "set_column" via package "Spreadsheet::WriteExcel" at test.pl line 49.

I don't understand it, because all other functions works fine.

Upvotes: 3

Views: 144

Answers (1)

daxim
daxim

Reputation: 39158

You need to call that method on a worksheet object, not a workbook.

Upvotes: 7

Related Questions