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 DIFFERENCE B/W QC 9.2 AND QC 10.0
For ex we are doing automate testing in that can we do some part of application recording, some part descriptive programing and some part general VB scripting like that .............
Does QTP provides any tools for parametarization?
How can I map test requirement to Test Set (multiple test cases)? Under test lab, I have multiple test cases. I would like to map 1 requirement to all test cases under that test set (in test lab)? Currently, I think QC only allow mapping 1 test requirement to 1 test case. Instead I would like to map 1 test requirement to multiple test cases under one test lab.
4 Answers CarrizalSoft Technologies, DST Global Solutions,
How you automate testscripts one by one or moduelwise or all at once
Tell me Three major differences between QTP & Winrunner?
This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10
I have application it is one digital clock with all minutes and seconds. you have to identify the time to verify weather the time displayed is correct time or not? How do you automate this scenario?
What is difference between Recording time object identification and Run time (Execution) time.
What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?
Hi Friends,I hav Just finished QTP course.Can any body suggest me which is the best place to go and post resume(Ban,Chennai,Pune,Mumbai,NCR,Kolkata).I mean how r calls in these cities,the best one?
How to get Links count in an web application,without descriptive programming?