Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 extension of qtp local repository?

0 Answers  


how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script

5 Answers   Cap Gemini,


Write a script to delete the a specific row (say 3rd) in a webtable.

0 Answers  


In what occasion we can specify global sheet and action sheet?

0 Answers  


what are the disadvantages of descriptiveprograming

5 Answers   GE,


Write a function which returns the addition of two numbers. give the value of the numbers outside the function.

3 Answers   SAP Labs,


In qtp,how to interact tool & application build?

1 Answers   Polaris,


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

6 Answers   iton, TATA,


What is the current version of QTP?

19 Answers  


what are the challenges you have faced while testing web based application using the automation tools ?

0 Answers  


what is a file system object in QTP

7 Answers  


Explain features of the latest version of qtp/ uft 12.1?

0 Answers  


Categories