Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, how can we retrieve a specific value from Excel Sheet
(Not datatable. for externel file).i mean to say from .xls
file.
and also tell me from xml file and .doc file.
and how can u parameterize ur script from .xls file.(Not
data table).
- 2 Answers
- 8193 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Hi I can divide ur question in to 3 parts
1. for xls file
2. for xml file
3. for doc file
1. For xls it is
GetCellData (Row, Column)
2. For XML
XMLFile(description).GetData
3. For Doc file it is
ReadLine( )
Any more querys in this then feel free to mail me to
testingwithshyam@gmail.com
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / nidhi jain
first you need to import datatable
Datatable.import("datatablename with path")
after importing table you need to call get method
Datatable.getCellData('columnname','datatable type')
| Is This Answer Correct ? | 1 Yes | 4 No |
Explain the new feature of UFT regarding the export of test results?
What are the features supported by UFT?
what is parameterisation?
What is LoadRunner?
plz can any one send me what is Automation Testing Frameworks.. Thanks in advance
How to execute a WinRunner Script in QTP?
If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?
regular expression in qtp standar check point for months from accepting months from january to december only
What are the advantages of QTP over WinRunner?
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!!?
how to get font size of a "WebEdit"
Step 3&4 are repeated until an the object in recognised uniquely.
WinRunner 
