how to retrieve data from the data table (from a particular cell)

Categories >> Software >> Testing >> Automation Testing >> QTP
Suggest New Category

how to retrieve data from the data table (from a particular
cell)

Question Posted / anand

7 Answers
31336 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to retrieve data from the data table (from a particular cell) ..

Answer / uday kumar_anem

First goto the the row and then retrieve the value from the
required cell.

datatable.SetCurrentRow(rowid)
datatable.Value(columnId,SheetId)
Ex:
datatable.SetCurrentRow(3)
val=datatable.Value(4,1)

Is This Answer Correct ?

23 Yes

3 No

how to retrieve data from the data table (from a particular cell) ..

Answer / milan

Uday your answer is right but if you have 3 values in
datatable then you will get the same value 3 times....

Is This Answer Correct ?

7 Yes

0 No

how to retrieve data from the data table (from a particular cell) ..

Answer / nanda

Hi Uday, u r exactly right.

Is This Answer Correct ?

5 Yes

2 No

how to retrieve data from the data table (from a particular cell) ..

Answer / nitin sharma

Function isparameterexist(sheetname,parametername)
on error resume next
if isparameterexist=true
err.clear
set param=datatable.getparameter("parametername").getsheet("sheetname")
if err.number<>0 then
isparameterexist=false
End IF
End Function

Is This Answer Correct ?

2 Yes

1 No

how to retrieve data from the data table (from a particular cell) ..

Answer / chaitanya chivukula

Print getvalueByrow("UserName","36")

Function getvalueByrow(colName,rownum)

DataTable.Get("SheetName").GetParameter(colName).RowByValue(rownum)

End Function

Is This Answer Correct ?

0 Yes

0 No

how to retrieve data from the data table (from a particular cell) ..

Answer / 428

428

Is This Answer Correct ?

4 Yes

5 No

how to retrieve data from the data table (from a particular cell) ..

Answer / dibyendu hembram

from my point of view there is no such function to retreive
data from a particular cell. what i think to retreive a
data from a particular cell we have to first create excel
sheet object and then by creating excel object we can use
the excel sheet function to access the particular cell

Is This Answer Correct ?

7 Yes

9 No

Post New Answer