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

hi i want license key for qtp 9.2 pls its adjust product name : quick test professional locking code :8 - 54A6A license type : seat license maintenance number : 88888888-8888 pls send license key to my email id borusu.ramkumar@gmail.com

3701


Can you write a script to check if the folder exists or not?

515


How to test background color and dynamic images during run time can you put the check point for moving objects?

1447


What is data driver in qtp?

574


In the website, the protocol has been changed http: to https what you will do? Tell me your approach?

561






Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay

2659


If we put all properties in mandatory and assistive list of Normal Identification, Do we still need Smart?

567


After executing the script in qtp suppose i found some script execute successfully and found some error.So how to report the status for both (i.e pass and fail report)in test director. For "fail" We use "defect tab" in testdirector. But for "pass" how to report it to TL.what is the process plz anybody ans

1673


What VBScript operators, functions, and statements do you use in QuickTest Professional?

2170


I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.

1581


Explain about the test fusion report of quicktest professional (qtp)?

537


Explain the concept of object repository?

526


Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?

646


What is qtp window?

566


What is the difference in the global and action sheet in qtp?

569