Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Perl Excel OLE help

by marto (Cardinal)
on Jan 06, 2010 at 21:32 UTC ( [id://815985]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://815985]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (2)
As of 2024-04-24 15:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found