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)

Answer / milan

Uday your answer is right but if you have 3 values in
datatable then you will get the same value 3 times....

Answer / nanda

Hi Uday, u r exactly right.

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

Answer / chaitanya chivukula

Print getvalueByrow("UserName","36")

Function getvalueByrow(colName,rownum)

DataTable.Get("SheetName").GetParameter(colName).RowByValue(rownum)

End Function

Answer / 428

428

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

How to use the object spy in quicktest professional 8.0 version?

0 Answers  

How to add object to object repository in qtp9.0 Suppose for brower yahoo home page

0 Answers  

I have written a code to fetch values fro access db and place in the fields. Iam using GetROProperty to fetch runtime values. Now i want to add runtime values to the access db in field v3. please help me. Its not writting in the db. Option explicit Dim con,rs,db,c Set con=createobject("adodb.connection") Set rs=createobject("adodb.recordset") con.Open "Driver={Microsoft Access Driver (*.mdb)};dbq=D:\Sales.mdb" rs.open "select * from tax",con Do while not rs.eof Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("incost").Set rs.fields("v1") Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("intax").Set rs.fields("v2") c=Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("outtax").GetROProperty("value") rs.MoveNext print c Loop Do while not rs.EOF rs.EditMode rs.Fields("v3").Value="3" rs.Update rs.MoveNext Loop Set rs=nothing Set con=nothing

0 Answers  

I m new to QTP? Is it necessary to know VB for learning QTP for Automation? Can I understand QTP excellently Without practical automation?

3 Answers  

how to reverse the string without using bultin functions(i.e mean mid,len ,reverse functions)

6 Answers   GE,

What scripting language QTP of?

4 Answers  

How to capture data from images in QTP and produce them in Excel sheet ? please ans...

3 Answers   Sapient,

Inserting a Call to Action is not importing all columns in Datatable of globalsheet. Why?

1 Answers   Crea,

I have qtp 9.5 demo ver,I am not able to record the yahoo broeser.so anyone can tell me what setting i have to do in QTP for yahoo brower recording. why its not recognise the object of yahoo browser????

0 Answers  

When to use descriptive programming?

0 Answers  

can i able to connect any version of qtp to any version qc

2 Answers  

How To write script in QTP For Field Validation Example: password Field is accepting A range 8-20 characters only.How to write script?

3 Answers