Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

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 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
Replies are listed 'Best First'.
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?

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2016-05-26 01:58 GMT
Find Nodes?
    Voting Booth?