http://qs1969.pair.com?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
[reply]
      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]
        Hi even when I do my $Sheet = $Book->Worksheets(8);
It fails to work,  I get same error

        [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom