Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Perl Excel OLE help

by Anonymous Monk
on Jan 06, 2010 at 23:47 UTC ( #816005=note: print w/replies, xml ) Need Help??


in reply to Perl Excel OLE help

"Invalid index" in METHOD/PROPERTYGET "Worksheets" seems to indicate 1) your worksheets don't have names or 2) your version of Worksheets method doesn't support names

Excel Object Model Overview Excel 2007 Developer Reference How to: Refer to Sheets by Name - Excel 2007 Developer Reference

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

    When I try to record a macro I get this: Sheets("Position").Select Which shows a Tab called Position. Also, the below code returns worksheet names and one of them is Position.

    for (1..$Book->Worksheets->Count) { print "$_: <", $Book->Worksheets($_)->Name, ">\n"; }
    I do not get it.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2022-12-01 13:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?