In Datatable having the data like this

S.no Name Address
1 raj hyderabad
2 suresh Mumbai
3 shyam chennai
4 dev banglore

i want to get the shyam row id & column id using scipting
i.e 3,3

Answer Posted / crazy boy

'' this is to search Shyam row and col in the webtable

DataRow=Browser("title:=givevalue").page("title:=GiveValue").webtable("name:=GiveValue").GetRowWithCellText("Shyam")
msgbox DataRow

ColumnCount=Browser("title:=givevalue").page("title:=GiveValue").webtable("name:=GiveValue").columnCount(DataRow)

for i=1 to Columncount
Data=Browser("title:=givevalue").page("title:=GiveValue").webtable("name:=GiveValue").getcelldata(DataRow,i)
if Data="Shyam" then
msgbox DataColumn
exit for
end if
next

msgbox "The Value is available in Row-->"&DataRow &" and Column -->"&DataColumn

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Cross browser testing? Does UFT support it?

786


Hi! Using Descriptive Programming How do we get Parent object for an object by writing script(DP). Say, i want to get a parent object for a "Link" in a web page by writing script in Descriptive Programming.

2294


Describe function procedure in vbscript.

773


i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1707


What is a programmatic description?

785






Can you brief the hurdles you faced during Automation testing?

763


how to find that tools work well with your existing system?

1602


Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?

1696


For which type of project the iterative model is suitable?

1540


How to get Traceability matrix from TD?

906


What are the benefits of quick test pro(qtp)?

739


Explain the use of action split in qtp?

734


Consider one application is open, clicking one menu will open another application in another browser. QTP does not catch the URL of the second browser(second application). can we capture it ?

1674


I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.

1723


What is quicktest professional window?

739