http://www.perlmonks.org?node_id=815985


in reply to Perl Excel OLE help

Check out Win32::OLE Excel Cheat Sheet.

Hope this helps

Martin

Replies are listed 'Best First'.
Re^2: Perl Excel OLE help
by mmittiga17 (Scribe) on Jan 06, 2010 at 21:51 UTC

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

    Thanks MM
      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
        Hi even when I do my $Sheet = $Book->Worksheets(8); It fails to work, I get same error