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

Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..

0 Answers  

Explain Descriptive Programming Types with Examples?

0 Answers  

For Usability testing, which is preferable Automation or Manual?

6 Answers  

Older version QTP is 8.2 and New version QTP is 9.2. My question is, Why it is QTP 9.2, why not 8.3,8.4 .... why it is not something ?

1 Answers  

what is the Descriptive Progarmming? how it is help to testers in QTP?

4 Answers   TCS,

Hi, i have a string like "INDIA". I need to display this string vertically in Msgbox?

3 Answers  

Can objects recognised without repository?

5 Answers  

how to test Web application using QTP software

0 Answers  

I heard that in Hyderabad Ameerpet is renowned for its training institutes it has , but from my own experience I can only say that this institutes have become money making machines losing their cognitive ability and ethics , can anybody tell me is there a good ins. in hyderabad for testing tools.?

2 Answers  

Hi I'm a beginner in QTP. So far I'm ok with Descriptive but stuck while implementing Hybrid Frame work. 1. I have created a Keyword file with .vbs ext set home=description.create home("title").value="Welcome to feests" set reglink=description.create reglink("name").value="register yourrestaurant / take away" set fbusname=description.create fbusname("name").value="business_name" set dispname=description.create dispname("name").value="display_name" set restchkbox=description.create restchkbox("name").value="restaurant" set cuiscate=description.create cuiscate("name").value="cuisine_categery1" set addline1=description.create addline1("name").value="address_line1" set pstcode=description.create pstcode("name").value="address_postcode" set cntry=description.create cntry("name").value="address_country" set mlandno=description.create mlandno("name").value="landline_no" set emailadd=description.create emailadd("name").value="email" 2. I have created an Function Library file as follows Function launch() bro="C:\Program Files\Internet Explorer\iexplore.exe" url="http://www.feests.com/" invokeapplication bro&" "&url Browser(home).page(home).Link(reglink).click End Function Function restregistration(karthik, teja, Ameerpet, UK) Browser(home).page(home).WebEdit(fbusname).set "karthik" Browser(home).page(home).WebEdit(dispname).set "teja" Browser(home).page(home).WebCheckBox(restchkbox).set "ON" Browser(home).page(home).WebList(cuiscate).Select "Indian" Browser(home).page(home).WebEdit(addline1).set "Ameerpet" Browser(home).page(home).WebEdit(pstcode).set "UK" Browser(home).page(home).WebList(cntry).select "United Kingdom" Browser(home).page(home).WebEdit(mlandno).set "023775347" Browser(home).page(home).WebEdit(emailadd).set "email@gmail.com" End Function 3. This is how I have called the keywords and Functions in QTP executefile"C:\Documents and Settings\karthik\Desktop\keywords.vbs" executefile"C:\Documents and Settings\karthik\Desktop\functions.vbs" launch restregistration karthik, teja, Ameerpet, UK, "email@gmail.com" Now the issue is, I'm trying to enter the email ID in WebEdit field. But I dont know what is the mistake I did, if I run the script in QTP it is showing following error Error: Expected identifier Line (2): "executefile"C:\Documents and Settings\karthik\Desktop\functions.vbs"". Can someone help me fix this, please!!?

0 Answers  

What is the differences between image check point and bit map check point?

0 Answers  

How to create scenario selector

0 Answers