How do you data drive an external spreadsheet?
Answer / santhosh
To data drive an external spreadsheet we just import that
spread sheet
In QTP,this can be done in two ways:
1) Using VB Script like datatable.ImportSheet "path of the
file",1,1
Where '1'specifies the file is for reading purpose
While another '1'specifies that the file is in ANSI Format
2) Anothe method u just right click on the Data sheet of the
QTP there u will find 'Import'option click on it and go for
the spread sheet,Now rest of the thing is same like by using
VB Script and counting the values in the data sheet and
retreiving from the Datasheet.
| Is This Answer Correct ? | 1 Yes | 1 No |
Hello Guys, Can anybody Explain me about Automation framework?? and how can we prepareAutomation Framework using QTP
how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods
Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)
CAN ANY ONE PLEASE EXPLAIN DIFFERENT TYPE OF FRAMEWORKS USED IN QTP?EXPLAIN EACH OF THEM?..POST TO VANILKUMAR_1981@YAHOO.CO.IN
If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?
WHAT IS THE DIFF BTW KEYWORD DRIVEN TESTING AND DATA DRIVEN TESTING?
how do you find the number of occurences of string QTP from the expression , " QTP+QTP=2QTP"
3. Anyone pls tell me as many points as possible for this question? what r the things to take into consideration before automating an application like; a). Identify whether the tool supports the appln or not. b). When there is lot of retesting and regression testing. c). ROI. d). When there is a need for running same script for multiple datas, etc. e). ---- f). --------- Pls give me more points.
Have you done batch testing in qtp? If yes how you are doing?
How to change the priorities of the recovery scenario properties?
Can we create a qtp test from qc?
With help of object repository,we can able to write the descriptive program manually?