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

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

by maa (Pilgrim)
on Dec 24, 2003 at 15:32 UTC ( #316861=note: print w/ replies, xml ) Need Help??


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

Hi,
If you look at the VB from a macro it is... Cells(r,c).Find(...).Activate which tells you that the $Sheet->Range("A1:B10")->Find() operation is returning something... that you can "->Activate" it means that it is a Range object you're getting back... so you can try
my $Range=$Sheet->Range("A1:B10")->Find("bob");

HTH - Mark


Comment on Re: Re: Using Win32::OLE and Excel - Tips and Tricks
Select or Download Code
Re: Re: Re: Using Win32::OLE and Excel - Tips and Tricks
by Anonymous Monk on Dec 30, 2003 at 09:27 UTC
    Wow... Thanks a lot!!! it was a great help, even though it took me a while to figure out how to extract the info I needed from the return value (it returns a hash so I had to do something like casting just to see the possible values...) cheers for the quick (and usefull) reply! grupy.
      That Tutorial is great, but I already made a Macro, and now it is quite a lot of work to convert it into perl. So is there a way to insert a macro (eg. from a textfile) into an existing excel workbook and run it form a perl program? Sorry for my lack of english but this isn't my native language.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2014-07-13 09:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (249 votes), past polls