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 descriptive programming?

5 Answers   Ordain Solutions,


anyone can explain about "Smart Identification" in QTP. what is the use of "Smart Identification" ???

1 Answers  


What is use of Global Sync Timeouts in QTP9.2?

2 Answers  


Analyzing the Checkpoint results ?

1 Answers   Crea,


What are the advantages of QTP over WinRunner?

5 Answers   CTS,


what is the extension for the test version of the script?

5 Answers   TCS,


Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?

0 Answers  


How many check points are there in QTP and what are they?

5 Answers  


Explain object spy in qtp.

0 Answers  


How can we close all webbrowsers which are opened in out desktop?

3 Answers  


if full in Object Repostoiory then how to load other Object Repository

2 Answers  


I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?

0 Answers  


Categories