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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

1602


How to modify the text checkpoint?

614


What is meant by Output Value in UFT?

565


Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji

2266


What are parameterizing tests?

549






If u r using library files (Instead of Check Points) , How do u do bitmap check ?

1455


i need qtp tutorial. pls send it to sridhar.k151@g mail.com

1640


What is QTP and the use of QTP in TD?

602


Hi All, I need code for how to execute qtp scripts from excell sheet

1465


if there is a web table of having row and colmns.a button is placed at 2nd row's 3rd column which is worked for both edit and delete..how to write script for the button to test both operation on the web table using desriptive programing.. plz help me on script wheather using getroproperty Q2)what is the command for taking valiue from a web table in qtp

23925


Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji

1324


what is the hierarchy to use properties in descriptive programming

1499


Explain the concept of object repository and how quicktest professional (qtp) recognises objects?

609


Which scripting language used by quicktest professional (qtp)?

662


whow much strong on VB and C?

1483