Spreadsheet::WriteExcel question

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!

Comment on Spreadsheet::WriteExcel question

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]