How do you data drive an external spreadsheet?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one say that where we can download the QTP trail version ??????????

1367


What are the trigger events in qtp?

575


What are the features of quick test pro(qtp)?

538


Can we record using all the modes in a single script? Explanation with example is appreciated

1392


What are the steps involved in recovery scenario wizard?

532






Diff b/w test scenario's and test Procedures?

1633


what is clean sweep?

1889


This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?

1472


images are dynamically changes how to compare two images with out using the bitmap

2007


How to run a test using quicktest professional (qtp)?

546


How do you compare the structure of 2 tables in database and check whether they are similar using qtp.

1479


What phases are involved in testing an application in qtp?

562


What is keyword view in qtp?

554


How many ways we can parameterize data in quicktest professional (qtp)?

586


Difference between test object and run time object?

596