http://qs321.pair.com?node_id=117798

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();

    [download]

    --RT
[reply]
[d/l]
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.

    --
    John.

[reply]

Back to Seekers of Perl Wisdom