Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve data from the data table (from a particular
cell)
- 7 Answers
- 32486 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
you written some code in qtp for opening google.com browser and entered some text inthe search text box and clicked search button. this is ur script.. before running this script i have already opened two google.com browsers. now am running the script what will happen? script will run or what?? Thanks... Nani
How did you use regular expressions in QTP and also in WR?
How smart identification works in qtp ?
Hi, I want to retrieve the cell data in the WebTable. For that I have defined a new test object under the browser and have given html tag and text as the test object properties. But while I try to identify it it says 'Object description is not unique'. I tried adding innerhtml, outerhtml, innertext and outertext along with the ordinal identifiers; but no use. What more properties need to be added to identify it? Also I want to enable smart identification for this object but the field is disabled in the object repository for this object alone(In QTP tools->object identification the enable smart identification checkbox is enabled). How do I enable it?
Apart from VB script What are the fundamental criteria to gain the knowledge to write QTP script without OR and recording ?
What is test object model in QTP?
What is quicktest professional (qtp)?
How to handle Run-time errors?
want to learn real time automation project(QTP)?
How do you perform testing on web based application using qtp 9.2?
Hi, How to give drop down values as input [Variable] from data table in QTP? If u know share with me.
What is Tree view?
WinRunner 
