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 ?    1 Yes 0 No
Santhosh
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
If u prepare bug report in Excel sheet . Is it possible to send thrw Test director? how it is? Wipro3
When we parameterise some field ex. Textbox is there any way that we can generate a specefic number of random values (For alphabetical values if possible) instead of manually entering values in the data table  2
what is Defect density, defect leakage, defect age,latentbed,yasid testing, interface Syntel3
Test cases for Traffic Signals AppLabs4
I am having trouble understanding #1 how to paramaterize a userid and password that I need to call in about 25 existing scripts. I need to know how to Create a Reuseable action for 25 existing scripts that will call the exact same userid and password? I need to know how to create a Reuseable action and then have it called by existing scripts being run in a batch.  1
Hi, My problem is as follows. I recorded a script that created Object repository of each action i recorded. But later I added one more step (which was to enter data in a textfield) into the script through expert view. But as no repository for this newly added step exists in the test, my script fails. So please help me to sort this problem that how can I create object repository of a new step in an existing test. Thanks everyone  1
What is the D/B Test managemet tool and bug trcking tool? Ans send to pbr.qtp@gmail.com Cap-Gemini1
What is the Diff between Image check-point and Bit map Check point? CTS12
when i perametarization of the test through outputcheckpoint,i have seen run time error i.e outputcheckpoint mismatch .Plz tell anybody to me(qtp).How to clear that?  1
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
explain keyword driven framework? Mindlance2
Hi I am from delhi, Now I can surely say that no institution of QTP here in Delhi After reading you people I want to get cry, from last six month I am trying to learn QTP, I have knowledge too but dont know VB Script. Now it appears that without learning QTP no one can learn complete QTP, I want to get a formal learning in QTP. Can you suggest me the best institution. and please let me know the charges and span of the course too. thanks in advance to you alkaa.dugaal@gmail.com  1
In one of the scripts the pwd in the DT was encripted. Can any one tell me how to I decript or undo the same? BirlaSoft2
Hi everybody, Can anybody tell me that how the QTP frameworks are implemented . I wanted to know with examples . Thanks in advance  1
Give me diffrent script in QTP for Webpage(Java and .Net),WindowsBased Applications,Java application,.Net application... Virtusa2
HOW CAN WE GET THE VALUE OF TEXT BOX IN QTP? can you give me sample script for this where there is some condition. like if "text" THEN msgbox() else endif Xavient7
Hi Guys, I tried to install java add-in for QTP 9.5 after the whole installation but it didn't install but then i also found in documentation saying that winrunner7.6 patch for java plugin would work fine with QTP. But when i tried to install from winrunner7.6 it asks me for the path of winrunner So my question is are we supposed to install winrunner for java add in to work on QTP. Please suggest me  1
The Senario is Steps to do 1.Entered userid in textbox 2.saved with details 3.i want to open user which i have created its in hurry.....  1
OPening of notedpad in QTP to write and execute the coding?  2
Is it possible to run qtp scripts in Test Director(Scripts are uploaded in Test director)???and also how to see the test results in test director???  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