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
- 8421 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / shyam
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 |
Post New Answer View All Answers
Describe function procedure in vbscript.
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
What is test object model in quicktest professional (qtp)?
How to sendKeys in QTP? Diff b/w sendkeys and device replay? Diff b/w function and Sub? Diff b/w Array and List Different Types of running Keys other than Fast, slow,Normal mode Regular expression for http://newtours.demoaut.com Difference between \w and \W How to generate script button Recording Types Different Types of Actions? Using DP performance degrades, If Yes why? How to close all the opened browsers? Diff b/w SystemUtil.Run and invoke application? If qtp not recognized the combo box How to select values from drop down?
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
What is the Command used to start the QTP
Why we use QTP ,We can use other tools like WR OrSilktest What r the options in Qtp that WR and Swilktest Does not have.
What is the use of sendkeys and what are send keys
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
What are the flaws in water fall model and how to overcome it?
Can we run test with out adding object in object repository? How it is possible?
Do you know SQL? I know SQL but i don't have any experience...that's it..No more questions ...simply he said " you can leave for the day" ...guys prepare SQL Quires before attending interview in bank of america...
When we r doing data driven test with chkpts, i want to insert formulae in data sheet but i didn't get. How we wil do that plz. explain in detail.
What are the different ways to invoke an application using QTP?
What are some test assets and related extensions of qtp?
