Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Get the row and column number

by Anonymous Monk
on Aug 25, 2007 at 00:14 UTC ( #634995=note: print w/ replies, xml ) Need Help??


in reply to Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks)
in thread Using Win32::OLE and Excel - Tips and Tricks

I am trying to do this is my program. Open an Excel File Search for a value in the excel file When i find the value i want to know the location of that value. For example if my excel file has 3 values A1-->apple A2-->Orange A3-->Grapes When i search the file for orange..it should say that orange found and return me the value A2. I am not able to find the location. Please help


Comment on Get the row and column number
Re: Get the row and column number
by Corion (Pope) on Aug 25, 2007 at 07:56 UTC

    Read the Excel object model documentation. For a cell (or Range) there likely is a function returning the coordinates of the upper left corner. Maybe it's Cell->Address or something containing R1C1 in its name.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2014-08-30 15:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (293 votes), past polls