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
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 |
Answer / sonal
msgbox (datatable.getsheet("Global").getparameter("Text").valuebyrow(3))
Is This Answer Correct ? | 1 Yes | 0 No |
datatable.SetCurrentRow(3)
a=datatable.Value("A",dtglobalsheet)
msgbox a
Is This Answer Correct ? | 1 Yes | 0 No |
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!!?
Can we create user defined functions in qtp?
What is the limitations of BVA?
How can we use the "CreateObject("Wscript.Shell")" in QTP and what is the definition and purpose of it?
What is qtpro? What is a quick test professional?
Problem with XML checkpoint in QTP ?
Hi. plz expalin abouit SetToProperty, SetRoProperty, GetToProperty, GetRoProperty,GetToPrperties. with examples.
What are metrics and matrix?
w is descriptive programming
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
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?
Suppose if a functionalityis not mensioned in requirement document and but its present in application. will it be consider as a bug and viceversa?