http://www.perlmonks.org?node_id=634995


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

Replies are listed 'Best First'.
Re: Get the row and column number
by Corion (Patriarch) 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.