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 |
what is debugging testing?
How to execute a WinRunner Script in QTP?
If you are using descriptive programming and you have two objects with the same name, so you are identiying them by name and index, how can you avoid errors if a third object with the same name is added at the begining of the page?
Explain the parameter in qtp?
how to get column count in datatable
Can you tell me the differences between writing the VB script manually for a application and recording the same application in QTP , with a example?
can we install qtp on server machine and do automation of application which is installed on client machine.If yes then how? If no then is there any other automation tool for this (client-server) senario.
hai friends i'm learning qtp now where we r using only record &playback frame work.and people r saying in realtime they won't use this frame work. if so what frame work actually using in realtime .and could you give explanation comaparing the record &play back fm and what ever FWyou r using in your organization. hoping cool response. thanx in advance
What is the use of defining a newobject in the object repository "Define New TestOject". How to use this further. If we define new testobject, how can it recognizes the objects properties of any application.
Hi, I am new to QTP and vb.script.How to start to write vb.script in QTP? Please give me suggestions?
when i try to recognise a winmenu item it does not allow me to do that but recognises it as window..i am using qtp 9.2 could someone help with this
unable to get item from the combobox using descriptive programing. can any one give me the peice of code to schedule the booking from one place to another using DESCRIPTIVE PROGRAMING.