Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2021-04-19 01:07 GMT
Find Nodes?
    Voting Booth?

    No recent polls found