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 |
What is the extension of qtp local repository?
how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script
Write a script to delete the a specific row (say 3rd) in a webtable.
In what occasion we can specify global sheet and action sheet?
what are the disadvantages of descriptiveprograming
Write a function which returns the addition of two numbers. give the value of the numbers outside the function.
In qtp,how to interact tool & application build?
how we can take data in the username field text box into variable in web application explain with example and give all functions to get data into variables
What is the current version of QTP?
what are the challenges you have faced while testing web based application using the automation tools ?
what is a file system object in QTP
Explain features of the latest version of qtp/ uft 12.1?