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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain different type of event trigger option.

710


Hi any body pls help me for QTP 11.0 software free demo version. i have to practice. Kindly send the link.or where i have to download.

1908


What are the types of object repositories? Which one is you using?

850


Explain about Test Fusion Report of QTP?

804


Difference between copy to action and call to action?

769


what is impact analysis on regression testing?

2227


is it possible to add sheets to excel at runtime

3581


can test automation improve test effectiveness?

1702


Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris

1949


How does qtp identify objects in the application?

814


What is qtpro? What is quick test pro?

804


any body can you help me what is the script to automate an comand promt

2191


Can anyone help.i need total excelsheet operations,shortcuts in testing environment from starting onwards....

1664


QTP 10.0 is not identifying web objects for IE 8.it is identifying like winObject.I installed HP patch QTPWEB_00037.Still getting issue

5841


Is it possible to call from one action to another action in qtp?

777