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

Answers were Sorted based on User's Feedback



In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

Answer / pushkar1206

a=datatable.GetSheet("Action1").GetRowCount
For i=1 to a
b=datatable.GetSheet("Action1").GetParameterCount
For j=1 to b
datatable.GetSheet("Action1").SetCurrentRow(i)
If datatable.Value(j,"Action1")="shyam" Then
msgbox i
msgbox j
End If
Next
Next

Is This Answer Correct ?    1 Yes 0 No

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

Answer / pravati

rowcount=Datatable.getsheet(id).rowcount
for i=1 to rowcount
colmncount=Datatable.getsheet(id).getparametercount
for j=1 to colmncount
Datatable.getsheet(id).setcurrentrow(i)
if Datatable.value(j,shetid)="shyam"
then msgbox i
msgbox j
exit for
end if
next
if Datatable.value(j,shetid)="shyam" then
exit for
end if
next

Is This Answer Correct ?    0 Yes 0 No

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

Answer / shekhar

a=
Browser("Creationtime:=1").page("micclass:=page").webtable("html
Id:=ctl00_contplhDynamic_ZeroChaosGrid_ctl00").GetRowWithCellText("ATT",,2)

b=Browser("Creationtime:=1").page("micclass:=page").webtable("html
Id:=ctl00_contplhDynamic_ZeroChaosGrid_ctl00").ColumnCount(a)

For i=1 to b

If
Trim(Browser("Creationtime:=1").page("micclass:=page").webtable("html
Id:=ctl00_contplhDynamic_ZeroChaosGrid_ctl00").GetCellData(a,i))=Trim("ATT")Then

msgbox "The correct row and column no" & a &" , " & i

Exit for
End If

Next

Is This Answer Correct ?    1 Yes 2 No

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

Answer / 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

More QTP Interview Questions

How many type of status messages are there ..explain?

5 Answers  


what is the silent mode in WR?

1 Answers  


Is it possible to call out to Java from QTP?

2 Answers  


Is there any thing that we can replace recovery scenario manager in QTP.

3 Answers  


This is the script generated by qtp plz can anyone write the same script using descriptive programming plzzzz guys do answer. Browser("orkut - login").Page("orkut - login").WebEdit ("Email").Set "rgovard" Browser("orkut - login").Page("orkut - login").WebEdit ("Passwd").SetSecure "47525d8be4926ea2f6e96b9a3f7472b6ae38" Browser("orkut - login").Page("orkut - login").WebButton ("Sign in").Click Browser("orkut - login").Page("orkut - home").Link ("Logout").Click Browser("orkut - login").Page("orkut - login").Sync Browser("orkut - login").Close

6 Answers  






hai friends i already ask this question but when i post the question the alignment goes wrong .....my question is we have a WEB TABLE ....assume that web table having 3 row's and 3 column here in 2nd row 3rd column having VISIT FACEBOOK link...now i want to check the VISIT FACEBOOK link is available or not ..if it's there i want to click the link ...then how to find the web table row or column count ....don't write the excel or data table script here friends .....consider that it's a WEB TABLE do a favour ...thank's

3 Answers  


How do we retrieve the content from a text box in a web page

2 Answers  


give me descriptive programing code sample flight application in qtp?

8 Answers   CA, IBM,


wt is playback facilityin qtp?

2 Answers   IBM,


hen do start automation testing after manual testing

1 Answers   Infosys,


how to reverse the string without using bultin functions(i.e mean mid,len ,reverse functions)

6 Answers   GE,


what is the purpose of SetTOProperty Method?

1 Answers   Cap Gemini, iGate, Wipro,


Categories