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

Hello Guys, Can anybody Explain me about Automation framework?? and how can we prepareAutomation Framework using QTP

3 Answers   CTS, IBM, Sapient,


how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

0 Answers  


Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)

0 Answers  


CAN ANY ONE PLEASE EXPLAIN DIFFERENT TYPE OF FRAMEWORKS USED IN QTP?EXPLAIN EACH OF THEM?..POST TO VANILKUMAR_1981@YAHOO.CO.IN

2 Answers  


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?

0 Answers  


WHAT IS THE DIFF BTW KEYWORD DRIVEN TESTING AND DATA DRIVEN TESTING?

1 Answers  


how do you find the number of occurences of string QTP from the expression , " QTP+QTP=2QTP"

5 Answers   IBM,


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.

1 Answers  


Have you done batch testing in qtp? If yes how you are doing?

0 Answers  


How to change the priorities of the recovery scenario properties?

0 Answers  


Can we create a qtp test from qc?

0 Answers  


With help of object repository,we can able to write the descriptive program manually?

1 Answers  


Categories