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

Give the syntax to load function at run time.

0 Answers  


could any help me please, how to work on visual foxpro application using UFT

0 Answers   NA,


User defined function in QTP

2 Answers   Lehman Brothers,


What is the difference betweent test and component?

1 Answers  


Give me exact application where we should use low level recording?

6 Answers   CTS,


How should i get name of the screen? Ex:There is a "submit" button.If i clicked on the submit button it opens a screen. I want that screen name.How can i get that screen name I dont have any property regarding that screen. If suppose we cliked on the screen , Then QTP captures the screen properties then i can get the screen name by using GETROPROPERTY But i want the screen name without clicking the screen. ("I am using the "settoproperty" for Second screen by using fist screen properties") Please tell me anyone

3 Answers   Livetek,


i have an array CAPGEMINI .....Here i need to check whether G is there or not ..how to do that and friends i have one big doubt that is whether it is array or string ,how we come to know that and where we consider that it's array ,where we consider that it's an string because when i want to find the length i have big doubt whether we need to use len function or ubound ... ans me for this TWO Questions any one please

7 Answers   Cap Gemini,


How does quicktest professional (qtp) identifies the object in the application?

0 Answers  


what is risks of testing a project?

5 Answers   AppLabs,


How to do excception handling ( error handling ) in QTP

6 Answers   Institute for Medical Education,


do you prepared framework,pls answer this

1 Answers  


Is qtp supports uni-code?

0 Answers  


Categories