Write script to fetch the data from global sheet where row
number is 3 and parameter is "text"

Answers were Sorted based on User's Feedback



Write script to fetch the data from global sheet where row number is 3 and parameter is "text..

Answer / kishan

Here is the code:

SheetName="Global"
Datatable.GetSheet(SheetName).SetCurrentRow(3)
print Datatable.Value("Text",SheetName)

Is This Answer Correct ?    10 Yes 2 No

Write script to fetch the data from global sheet where row number is 3 and parameter is "text..

Answer / sonal

msgbox (datatable.getsheet("Global").getparameter("Text").valuebyrow(3))

Is This Answer Correct ?    1 Yes 0 No

Write script to fetch the data from global sheet where row number is 3 and parameter is "text..

Answer / pushkar1206

datatable.SetCurrentRow(3)
a=datatable.Value("A",dtglobalsheet)
msgbox a

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More QTP Interview Questions

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  


Can we create user defined functions in qtp?

0 Answers  


What is the limitations of BVA?

1 Answers   IBM,


How can we use the "CreateObject("Wscript.Shell")" in QTP and what is the definition and purpose of it?

2 Answers  


What is qtpro? What is a quick test professional?

0 Answers  






Problem with XML checkpoint in QTP ?

0 Answers  


Hi. plz expalin abouit SetToProperty, SetRoProperty, GetToProperty, GetRoProperty,GetToPrperties. with examples.

6 Answers  


What are metrics and matrix?

0 Answers  


w is descriptive programming

2 Answers   TCS,


In Datatable having the data like this S.no Name Address 1 raj hyderabad 2 suresh Mumbai 3 shyam chennai 4 dev banglore i want to get the shyam row id & column id using scipting i.e 3,3

4 Answers   Broadridge,


I want to open a Notepad window without recording a test and I do not want to use SystemUtil.Run command as well How do I do this?

12 Answers  


Suppose if a functionalityis not mensioned in requirement document and but its present in application. will it be consider as a bug and viceversa?

2 Answers  


Categories