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 |
can we call runaction in the funcion
Recovery Manager means..?
How to get align property of the link on web page?
What is meant by Pseudo Code?
Explain about the Test Fusion Report of QTP ?
is qtp 9.2 supported for firefox browser3.0?bcoz when i tried to create scripts with the application run on firefox browser 3.0 then qtp 9.2 didn't ct=reate the scripts?
How you are maintaining shared object repository in your team or your project?help me plz
How to export data present in Datatable to an ".xls" file?
What is the Dynamic Scenario in QTP? And also anybody give the example for this?
We have opened three browser such as Facebook,Gmail,Amazon,I want to generate the script of Login of Amazon application, but while adding the object such as edit box(user id,password) in OR is not added.Could you please resolve my issue
WHAT ARE THE DISADVANTAGES OF SHARED REPOSITORY?
Where to use Property Let, Property Get, Property Set in UFT