How do you data drive an external spreadsheet?



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

Post New Answer

More QTP Interview Questions

What is the difference between keyword view and expert view?

0 Answers  


How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?

0 Answers  


What is the difference between QTP 8.2 object repository and QTP 9.2 object repository Any body have an please give Answer Mail id: nagireddy.sn@gmail.com

5 Answers   IBM,


What are the different recording modes and how do they work?

0 Answers  


Think and Reply.. can we parameterize radio buttons, check boxes? as in flight web site on flight preference page, choosing different flight produces trouble if from port and to port been parameterize, and runs. Try it by own you will get the error.

3 Answers   Patni,






w is recovery senario manager

3 Answers   Infosys,


Hi guys can any plz help me how to send fax in sample Flight Appication

1 Answers  


How can i check elements sorted in dorpdown using qtp..

1 Answers   Value Labs,


How to find local host name using QTP?

6 Answers  


Did you find anything in your project that QTP proved inefficient to perform?

1 Answers  


hi friends can anyone tell me where can i find descriptive programming material please send me the link also,from which i can download the material

1 Answers  


For Data-Driven testing can you use micro soft word document instead of using Datatable what is your approach?

0 Answers   Nokia,


Categories