In Datatable having the data like this S.no Name Address 1 r

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

Question Posted / karthik

4 Answers
7579 Views
Broadridge, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

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

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

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

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

Answer / shekhar

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

In Datatable having the data like this S.no Name Address 1 raj hyderabad ..

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

Post New Answer