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
Replies are listed 'Best First'.
Re: Can't locate object method "set_column" via package "Spreadsheet::WriteExcel"
by marto (Bishop) 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 lurking in the Monastery: (17)
As of 2015-07-28 16:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (258 votes), past polls