how to retrieve data from the data table (from a particular
cell)
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
How to use Regular Expressions in QTP
Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??
How many tabs are available in debug viewer pane?
str="ramanareddy12345@gmail.com"to count alphabets,numarics and special charcters pls any one knows send to answer
What is the another extension name of library file. If that is exist than what's the difference between them.
For which type of projects the iterative model is not suitable?
What are private functions in QTP? How they can be called from the function library?
What are the different attribute used with regular expression?
Explain the concept of object repository & how QTP recognises objects?
in QTP,how to write a descriptive program for "yahoo" or "gmail" Login page
what is the frame work in J-meter?
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?