Re: How do I print the page header/footer from an excel spreadsheet

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.

my $Book = $Excel->Workbooks->Open('test.xls'); 
my $Sheet = $Book->Worksheets("Sheet1");
$Sheet->Activate();    

for my $position ( qw( Header Footer ) ) {
  for my $element ( qw( Left Center Right ) ) {
    my $item = $element . $position;
    print "$element$position: ", $Sheet->PageSetup->$item, "\n";
  }
}
[download]

++ to the first person to show me how to eliminate $item - I feel like it is unnecessary.

--
I'd like to be able to assign to an luser

Comment on Re: How do I print the page header/footer from an excel spreadsheet Select or Download Code

Replies are listed 'Best First'.
Re^2: How do I print the page header/footer from an excel spreadsheet by boat73 (Scribe) on Nov 08, 2006 at 13:32 UTC
Perfect, thanks much	[reply]
Re^2: How do I print the page header/footer from an excel spreadsheet by friedo (Prior) on Nov 08, 2006 at 13:50 UTC
++ to the first person to show me how to eliminate `$item` - I feel like it is unnecessary. `$Sheet->PageSetup->${ \"$element$position" };` [download]	[reply] [d/l] [select]
Re^3: How do I print the page header/footer from an excel spreadsheet by bmann (Priest) on Nov 08, 2006 at 13:54 UTC
You can use the "hash syntax" to access object properties (see Win32::OLE documentation)~~Properties of an object are implemented as a hashref~~, so more simply: `$Sheet->PageSetup->{"$element$position"} # or $Sheet->PageSetup->{$element . $position}` [download] Update: pr	[reply] [d/l]
Re^4: How do I print the page header/footer from an excel spreadsheet by friedo (Prior) on Nov 08, 2006 at 14:12 UTC
Not all objects work that way under the hood, though. It's bad practice to access the hash data directly. (Though it's probably not very good practice to use arcane syntax for dynamic method names either!)	[reply]
Re^5: How do I print the page header/footer from an excel spreadsheet by bmann (Priest) on Nov 08, 2006 at 14:21 UTC
Re^6: How do I print the page header/footer from an excel spreadsheet by friedo (Prior) on Nov 08, 2006 at 14:27 UTC
Some notes below your chosen depth have not been shown here

• hippo

‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!

• erzuuli

‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.


We don't bite newbies here... much
	PerlMonks