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   To Refer this Site to Your Friends   Click Here
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 can we open an Excel sheet through the script
 Question Submitted By :: Krishnachand
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can we open an Excel sheet through the script
Answer
# 1
This question is related to automation.  As an example we
can open an excel sheet in QTP using the library functions
available in the VB scripting.
 
Is This Answer Correct ?    4 Yes 7 No
Bhaskar Pothuri
 
  Re: How can we open an Excel sheet through the script
Answer
# 2
a)	In QTP data table have two types of the Excel sheet.
b)	If the extra Excel sheet wants then you create in 
the data table window in QTP. This facility is possible in 
QTP data table window.
c)	If you want script to excel sheet then start the 
record and open the one new excel sheet then stop the 
record after check script. That is the script of the excel 
sheet.
d)	Once do this function of the excel sheet. if  you 
get the scripts.



My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in 
If any body want full explain send the mail
 
Is This Answer Correct ?    3 Yes 7 No
K.chandra Sekhar
 
 
 
  Re: How can we open an Excel sheet through the script
Answer
# 3
InvokeApplication("C:\Documents and Settings\All 
Users\Start Menu\Programs\ExcellSheet")
 
Is This Answer Correct ?    1 Yes 5 No
Srikanth
 
  Re: How can we open an Excel sheet through the script
Answer
# 4
If you want to open Excel sheet using QTP, follow the below 
script:
Dim objexcel
Set objExcel = createobject("Excel.application") 

Set objWB = objExcel.Workbooks.Open("FileName")
Set objWS = objExcel.ActiveWorkbook.Worksheets("SheetName")
objexcel.Visible = True
 
Is This Answer Correct ?    9 Yes 1 No
Uday Kumar_anem
 
  Re: How can we open an Excel sheet through the script
Answer
# 5
HI All,
 
Try for this three ways given below : 

 1. 
  SystemUtil.Run "excelsheet path"

 2.
  Dim xl 
  Set xl=CreateObject("Excel.Application")
  xl.Visible=True
  xl.WorkBooks.Open "ExcelSheet path"
  xl.ActiveWorkBook.Save
  xl.Application.Quit
  Set xl=Nothing

3.Dim xl
  Set xl=CreateObject("WScript.Shell")
  xl.Run "Excel.exe"
 
Is This Answer Correct ?    5 Yes 0 No
Sreekanth Chilam
 
  Re: How can we open an Excel sheet through the script
Answer
# 6
We can open a excel sheet from the given location. 
First you write a script in ksh shell and mentioned the
actual path of the sheet and try to run your script.
 
Is This Answer Correct ?    0 Yes 1 No
Mukesh Raghav
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
setroproperty and getroproperty difference Ordain-Solutions3
i want to handle all the unwanted pop up through QTP i done that with recovery scenario but it need some title of pop up but i want that it should handle all the pop up even i don't give the title of that pop up in recovery scenario is there any general way to handle all the pop up please help  3
What is the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?  1
Up to how much VB scripting knowledge and what type of VB script knowledge is required for a QTP test engineer for real time to work ?  2
I am not finding pages and links in object spy on web testing. I am only getting window and winobject. where is the problem? thanks  2
What is the difference between Action and Function.? when both has the same functionaltiy, when do we choose Action and when do we choose Function..?? DST-Global-Solutions2
Hi all im having a pop up validation browser which is 20 in number, i want to close those similar pop browsers one after the other, is there any specific code for that? i tried by giving creation time & putting in a loop but it dint work? valid working answers will be greatly appreciated McAfee2
How can we redirect QTP results in to a excel sheet after the execution Virtusa2
i want 8.2 and 9.2 dacuments plhelp any body sand it to my id sandhyat1@yahoo.co.in Siloka3
How can we retrieve the links from a web page where links are dynamically changing(for eg take a online shopping website) and then we have to click on all the links present in the webpage and go to the repective pages and again come back to the first page..  2
Is it possible for QTP to capture the objects in word document.If so please give me the code.Thank you.  1
What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.  1
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop (i.e. I first connect to remote desktop from my machine in order to run the application). I am able to record the script successfully with QTP running on my machine and application running on remote. However, when i run the recorded script, system fails to run it and indicates me that it does not identify the object. Is it possible to record and play while QTP and AUT are not on same machine?  6
what will be the stmt if record any edit box in the Web application ? eSymbiosis2
how can we retrieve ten rows from the data table using loop concept?  3
Question:how many types of repositories in QTP9.2?and explain??  3
Suppose i have a script which is having 100 lines.I want to execute that script starting from line no 75.means first qtp should read the script from line no 75 how can u do it. Lehman-Brothers5
What is a Run Time Data table?  1
Hai Guys, can anybody show me how to write automaed test cases using VB scprit(examples)...i had an interviw soon...please guyz send as quickly as possible  5
Can any one please explain hwo to test client/server application using QTP? Value-Labs2
 
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