Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Get the row and column number

by Anonymous Monk
on Aug 25, 2007 at 00:14 UTC ( [id://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

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.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2024-03-29 06:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found