in reply to Perl Excel OLE help

You could use a loop like this to set the $Sheet object equal to the Position worksheet:

for (1..$Book->Worksheets->Count) { my $name = $Book->Worksheets($_)->{Name}; if ($name =~ /Position/) {$Sheet = $workbook->Worksheets($_)}; }


chinman

Replies are listed 'Best First'.
Re^2: Perl Excel OLE help
by mmittiga17 (Scribe) on Jan 07, 2010 at 00:16 UTC
    This seems to work, thanks chinman!!!!