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

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

More QTP Interview Questions

How to use Regular Expressions in QTP

1 Answers  


Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??

0 Answers  


How many tabs are available in debug viewer pane?

0 Answers  


str="ramanareddy12345@gmail.com"to count alphabets,numarics and special charcters pls any one knows send to answer

3 Answers   Ziynx,


What is the another extension name of library file. If that is exist than what's the difference between them.

2 Answers   Synechron,


For which type of projects the iterative model is not suitable?

0 Answers  


What are private functions in QTP? How they can be called from the function library?

0 Answers   HCL,


What are the different attribute used with regular expression?

0 Answers  


Explain the concept of object repository & how QTP recognises objects?

1 Answers  


in QTP,how to write a descriptive program for "yahoo" or "gmail" Login page

1 Answers  


what is the frame work in J-meter?

0 Answers  


i am giving.multiple names like ram,raj,san etc....pls enter & search these names in google pade edit box through script... i told to interviewer, using Ms excel & test easily..but interviwer not happy with that answer?

2 Answers   Accenture,


Categories