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
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 |
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 |
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 |
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 |
what is action in QTP?
What is exact meaning of Database Checkpoint in QTP 9.2 and what are the different types of the database check points?
What is FRAME WORK? How many Frameworks can QTP supports?
i m fresher iwant to know about testing what is the scope of testing field.i m aware in manual testing shall i go to automatiuon testinh directly or if any work experinc in manual testinh then only i go to manually automation testing.
Hi i have a webtable which is having 7 columns and 6 rows of data in that table of 4th and 5 th column each row is partiotioned into 3 sub rows i want to verify in each partitioned rows of corresponding row for ex values will be like this 0 / 1 ,26/28.if it is 0/1 i want to skip only if any num/num greater than 1 i want to click.
I want to open a Notepad window without recording a test and I do not want to use SystemUtil.Run command as well How do I do this?
suppose u have two send buttons(same width,height,font) on an application write a descriptive programming
How to run a script from lines 50 - 100 alone (if the script has 1- 200 lines of code)?
Hi i want to export the data from applicatioon to excel and later i want to import and use it for my scripts hoe can i do this?
Please anybody can tell the where can i get the information about pharma and bank testing, i put the pharma&bank projects in my resume, so i dont know what to tell about them, so where can i get the information and what we test for these, i need domain information, what r the screen we test?
what is framework? which frame work u follow for writting script?
In QTP can we feed the out of one browser(internet explorer) as an input to the another browser(mozilla firefox)? If yes explain how to do it with an example.