Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Spreadsheet::WriteExcel question

by Anonymous Monk
on Oct 09, 2001 at 21:15 UTC ( #117798=perlquestion: print w/replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi, Is the $worksheet->set_landscape() page set-up option supported in the 0.33 version of Spreadsheet::WriteExcel ? (I'm using the .26 version, and when I tried to add $worksheet->set_landscape(); , I got the error Can't locate object method "set_landscape" via package "Spreadsheet::WriteExcel::Worksheet" . Because the documentation says that not all of Excel's page set-up options are available in this release but they will be added in subsequent releases, I am hoping that if I install the new version, this will fix the problem; can anyone confirm this?) Thank you very much!

Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel question
by RhetTbull (Curate) on Oct 09, 2001 at 22:11 UTC
    Yes, it appears to be. The easiest way to find out the answer to this question is to read the docs on cpan. Example code follows:
    #!/usr/local/bin/perl use warnings; use strict; use Spreadsheet::WriteExcel; my $workbook = new Spreadsheet::WriteExcel("new.xls"); my $worksheet = $workbook->addworksheet(); $worksheet->set_landscape();

Re: Spreadsheet::WriteExcel question
by jmcnamara (Monsignor) on Oct 10, 2001 at 01:04 UTC

    The set_landscape() method was added in version 0.32 of Spreadsheet::WriteExcel. An upgrade will fix your problem.

    Version 0.34 of the module should be released next week.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://117798]
Approved by root
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (5)
As of 2017-11-20 00:39 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (282 votes). Check out past polls.