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

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

$Sheet->PageSetup->${ \"$element$position" };
[download]

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

Replies are listed 'Best First'.
Re^3: How do I print the page header/footer from an excel spreadsheet by bmann (Priest) on Nov 08, 2006 at 18: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 19: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 19:21 UTC
Not sure if you replied before the update, but why is it bad practice? I know some properties can't be set that way, but what problems do avoid by not using the hash syntax?	[reply]
Re^6: How do I print the page header/footer from an excel spreadsheet by friedo (Prior) on Nov 08, 2006 at 19:27 UTC
Re^7: How do I print the page header/footer from an excel spreadsheet by bmann (Priest) on Nov 08, 2006 at 19:50 UTC