http://qs321.pair.com?node_id=582941


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