Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

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

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 musing on the Monastery: (11)
As of 2016-10-25 07:00 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (315 votes). Check out past polls.