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 review
WHAT IS DIFFERENCE B/W QC 9.2 AND QC 10.0
write a qtp script to see time in windows command prompt? its urgent....
What are the advantages of Object Repository?
What is active screen?
hi all, I want to know about the QTP scripts, i have read more books but all areis to be a theory so how can i improve my script skills. if anybody knows about qtp scripts plz guide me and i need a sample scripts.my mail id is karthis4u@gmail.com, 9986667831 If you all have any data send it to akadi111@gmail.com
After creating testcases, how do you start testing in QTP? what methodology will follow?
7 Answers Actran, American Well,
why use Description programming? what is advantages and disadvantage of this methods?
How to do Laod testing for web based Application?
What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?
How to open a new test using QTP?
How to capture dynamic objects in qtp like mark up text