Re^2: Perl Excel OLE help

I have looked every where including that site. Can not seem to get it to pull sheet 8.

Thanks MM

Comment on Re^2: Perl Excel OLE help

Replies are listed 'Best First'.
Re^3: Perl Excel OLE help by chinman (Monk) on Jan 06, 2010 at 23:42 UTC
Hi MM, You cannot access the sheet by name this way, because Excel is expecting the sheet index and not the name. You need to use the sheet index for 'Position', thusly: `my $Sheet = $Book->Worksheets(8);` Regards, chinman	[reply] [d/l]
Re^4: Perl Excel OLE help by mmittiga17 (Scribe) on Jan 06, 2010 at 23:53 UTC
`Hi even when I do my $Sheet = $Book->Worksheets(8); It fails to work, I get same error` [download]	[reply] [d/l]