Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

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

by Anonymous Monk
on May 09, 2002 at 20:35 UTC ( #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
What am I doing wrong?


Comment on Re: Using Win32::OLE and Excel - Tips and Tricks
Download Code
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';

    C-.
      ah, exactly right. many thanks. I'm continuously amazed and impressed by the Perl community. Dooj

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2014-08-02 04:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Who would be the most fun to work for?















    Results (54 votes), past polls