How can we open an Excel sheet through the script
Answer Posted / sreekanth chilam
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 ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to save your test using quicktest professional?
Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers
if numbers are always changing write a script for that
explain structured testing? plz guys with exp. do answer
Dis advantages of XML checkpoint ?
I have qtp 9.5 demo ver,I am not able to record the yahoo broeser.so anyone can tell me what setting i have to do in QTP for yahoo brower recording. why its not recognise the object of yahoo browser????
What are the Application Functions available in QTP?
An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))
Why do you create a text checkpoint on a Web application? What is the purpose of the Close method?
How do you configure QTP AND Test director?
Why bpt?
I want to do QTP Certification what is the pattern of Question paper.
Where is the Bitmap checkpoint information stored?
What do you to script when objects are removed from application?
In qtp, explain what is keyword driven automation framework?