Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Using Win32::OLE and Excel - Tips and Tricks

by Anonymous Monk
on May 09, 2002 at 20:35 UTC ( [id://165497]=note: print w/replies, xml ) Need Help??


in reply to Using Win32::OLE and Excel - Tips and Tricks

I couldn't get your snippet above to get the outer edges of the rows and columns to work. I get the error 
#[Thu May  9 16:39:02 2002] fndsxmit.pl: Win32::OLE(0.1501) error 0x80
+020005: "Ty
#pe mismatch"
#[Thu May  9 16:39:02 2002] fndsxmit.pl:     in METHOD/PROPERTYGET "Fi
+nd" argumen
#t "SearchDirection" at fndsxmit.pl line 1350

[download]
What am I doing wrong?

Replies are listed 'Best First'.
Re: Re: Using Win32::OLE and Excel - Tips and Tricks
by cacharbe (Curate) on May 10, 2002 at 01:10 UTC
    hmmm. It makes me think that you didn't include the line: 
     
use Win32::OLE::Const 'Microsoft Excel';

    [download]

    C-.
[reply]
[d/l]
      ah, exactly right. many thanks. I'm continuously amazed and impressed by the Perl community. Dooj
[reply]

In Section Tutorials

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://165497]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2025-07-08 15:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found
    Notices?
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.