ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
How do you data drive an external spreadsheet?
 Question Submitted By :: Sreeprasad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you data drive an external spreadsheet?
Answer
# 1
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 ?    0 Yes 0 No
Santhosh
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
what is the Exact Meaning of Environment Variables? AppLabs7
Where the text version of script file located in file system?  1
Hai anyone please "Explain about Framework in QTP?"  4
w is output value MBT2
take one exmple and write on that discriptive programe in qtp?  1
How i can test the background color of the records displayed in a Table. Eg i have a .net desktop application and there is a Table(swftable) with records displayed in the grids. i have to validate whether the 1st record is displayed in white background color and 2nd record in light blue background color...But the constraints is that once user click on the first record...the background color changes to grey.......Plze let me now how to validate this with QTP 9.2. Accenture7
What are the Latest Feature are added In QTP 9.2? Infotech2
I dont know how to configure non standard objects to standard objects in QTP9.2 can i have someone explain me in breify? Wipro2
QTP identifying the child tabs in a maintab like tab_1,tab_2,tab_3,tab_4 while using a for loop for these tabs.its not proceeding from _1 to _2. How can i use "for loop " Livetek2
what sort of things what u put in Bug Report ?  1
Hi,How to write regular expression for inbox(10) {here 10 is changing while playback}.tell me the pettern.  3
How to see entire results at the same timeafter the batch run.. Cannot see the entire results at a time. Is there a easier way view everthing at same,as our batch file very large  2
Wht are the BY default Add-ins in QTP 9.2 version and what all are differences between 8.2 and 9.2 Siemens1
What is the Difference between current version of QTP and QTP 8.2. Pls kidly Anybody let me know. Thanks in advance. TCS1
How to load a object repository in QTP during runtime? Virtusa1
Hello Everybody, Please tell me the concept of recovery management in QTP by giving any practical example of it. Thanks, Gaytri  6
What r the features of QTP9.2,other than QTP8.0 What r the extre features of QTP9.2.  1
how u test a frame in a web page using QTP? Accenture1
When to Insert transactions in QTP? Siemens2
in flight reservation application. when i entered flyto combobox as london. and i have to check this london is present in flyfrom combobox.give me the code with good explanation. extention to this question. at each iteration i have to put(WRITE) the fly from and fly to city in database table  1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com