Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Can't locate object method "set_column" via package "Spreadsheet::WriteExcel"

by vikram007
on Oct 17, 2012 at 09:27 UTC ( #999504=perlquestion: print w/ replies, xml ) Need Help??
vikram007 has asked for the wisdom of the Perl Monks concerning the following question:

use Spreadsheet::ParseExcel::SaveParser; use POSIX qw/strftime/; my $parser = Spreadsheet::ParseExcel::SaveParser->new(); my $readxls = $parser->Parse('perl_1.xls'); my $worksheet = $readxls->worksheet('sum-base'); my $sw_workbook = $readxls->SaveAs('perl_2.xls'); $worksheet= $sw_workbook->set_column(2, 2, 10);
<\i am getting error like > Can't locate object method "set_column" via package "Spreadsheet::WriteExcel" at t5.pl line 23

Comment on Can't locate object method "set_column" via package "Spreadsheet::WriteExcel"
Select or Download Code
Re: Can't locate object method "set_column" via package "Spreadsheet::WriteExcel"
by marto (Chancellor) on Oct 17, 2012 at 09:39 UTC
Re: Can't locate object method "set_column" via package "Spreadsheet::WriteExcel"
by NetWallah (Abbot) on Oct 17, 2012 at 15:13 UTC
    "set_column" is a WORKSHEET method, not a WORKBOOK method.
    Your "$sw_workbook" is a Work BOOK.

                 I hope life isn't a big joke, because I don't get it.
                       -SNL

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://999504]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2014-07-14 02:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (254 votes), past polls