Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

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] Win32::OLE(0.1501) error 0x80 +020005: "Ty #pe mismatch" #[Thu May 9 16:39:02 2002] in METHOD/PROPERTYGET "Fi +nd" argumen #t "SearchDirection" at line 1350
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';

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://165497]
[choroba]: Down for everyone of just me
[shmem]: "Problem loading page" here
[marto]: seems down
[planetscape]: Able to ping but not connect with either Opera or Firefox
[thanos1983]: same here...
[choroba]: marto ;-)
[Discipulus]: after an error now is back
[shmem]: looks like a 302 loop - "The document has moved here"
[Discipulus]: ..but only http not https

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (13)
As of 2018-02-20 11:53 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (271 votes). Check out past polls.