Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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

by Albannach (Prior)
on Nov 08, 2006 at 18:01 UTC ( #582941=note: print w/ replies, xml ) Need Help??


in reply to How di I print the page header/footer from an excel spreadsheet

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"; } }
++ 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
Re^2: How do I print the page header/footer from an excel spreadsheet
by boat73 (Scribe) on Nov 08, 2006 at 18:32 UTC
    Perfect, thanks much
Re^2: How do I print the page header/footer from an excel spreadsheet
by friedo (Prior) on Nov 08, 2006 at 18:50 UTC
    ++ to the first person to show me how to eliminate $item - I feel like it is unnecessary.
    $Sheet->PageSetup->${ \"$element$position" };
      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}
      Update: pr
        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!)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://582941]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (5)
As of 2014-08-30 02:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (291 votes), past polls