Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
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 surveying the Monastery: (5)
As of 2015-07-05 23:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (68 votes), past polls