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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/allinter/public_html/common/queries.php on line 15
Question
How to get data from excel sheet to the script? write the
script.
 Question Submitted By :: Prasad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to get data from excel sheet to the script? write the script.
Answer
# 1
datatable.import("xlsheetname.xls")
 
Is This Answer Correct ?    0 Yes 0 No
Cheryl
 
  Re: How to get data from excel sheet to the script? write the script.
Answer
# 2
close the excel sheet which you want to open in QTP
first row will always be column name which will be used in 
script

datatable.import("c:\path,,,\xlsheetname.xls")
a=datatable.value("jksdfj")
 
Is This Answer Correct ?    0 Yes 0 No
Srinath
 
 
 
  Re: How to get data from excel sheet to the script? write the script.
Answer
# 3
DataTable.Import("xlsheetname.xls")
For i=1 to DataTable.GetRowCount step 1 
DataTable.SetCurrentRow(i)
........................................
.......................................
	 Stmts
......................................
...................................
DataTable.SetNextRow
Next
 
Is This Answer Correct ?    0 Yes 1 No
Rao' Prasad
 
  Re: How to get data from excel sheet to the script? write the script.
Answer
# 4
datatable.Importsheet "D:\Keyword\Test Data\data.xls"
 
Is This Answer Correct ?    0 Yes 0 No
Murali K M
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
How will u find that how many List boxes( and check boxes) are present in one particular window  6
what is key word driven frame work how to use keyword driven frame in QTP in a project AppLabs1
How to get line numbers in your editor in expert view?  1
Hi Guys, I am very new to QTP tool , In real time environment how to test the application with this tool, 1. How to load application in QTP tool 2. How to write test script in QTP. 3. In manual testing we test login box (user id , password) how can we test this kind of testing with QTP tool with examples . Please guys put some focus on my questions , real time ecperienced answers would be appreciate, advance thanks ,please guys i am expecting ur answers as soon as posible IBM1
How to call .vbs functions in QTP? plz Explain indetail Wipro2
How can we write script for a .net application in QTP? Can we use VB Script for .net application.  1
hi friends i have 4 yrs exp in testing and 2 yrsexp in QTP.currently aim working in mnc in north as a permanent employer .iam looking for job in south is there any openings plz let me know my mail id is bjr@aol.in its very urjent  4
what is the diff between Procedure and function iFlex1
What is difference between QC and TD?  6
Discuss QTP Environment.  1
What does it mean when a check point is in red color? what do u do?  1
Could anyone please tell me one situation where you have used recovery scenarion in real time with an example?  3
for example one window is there, the window contains how many edit box's i want script? i know the script but that is not exact answer.... The script is like this .......... set a=description.creation() a("Native class")="WinEdit" b=window("Flight Reservation").childobject(a).count msgbox b if u found exact answer please getback to me? raju.ippali@gmail.com 9823257761  1
What are the recording modes and executing modes avialble in QTP? Polaris3
What is DOM  1
What is BPT?  2
what is a test strategy & what is the difference between test strategy & test plan?  3
What is the BPT(bussiness process testing ).and what is the main difference between BPT and QTP EDS2
what is reusable action and how the same can be implemented (process)?  1
what is difference between wait and synchronization point. Intel3
 
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