Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Perl Excel OLE help

by marto (Cardinal)
on Jan 06, 2010 at 21:32 UTC ( #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
      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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://815985]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2022-12-07 00:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?