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