Interested to Buy Any Domain ? << Click Here >> for more details...
How can we open an Excel sheet through the script
- 8 Answers
- 44496 Views
- eSymbiosis, I also Faced
- E-Mail Answers
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 does qtp recognize objects in aut?
What is the difference between local and shared object repository in qtp?
To retrive the test data which tool vl use and whats basis u vl write test data? its urgent
How many scripts did you have?
what is impact analysis on regression testing?
What is the difference between qtp and selenium?
How to explain a banking project in interview as a test engineer???
Explain the concept of object repository and how quicktest professional (qtp) recognises objects?
1.explain end to end process of qc,2.how many tabs are in qc9.0,qc10.0 3.what is review, how many reviews are following in aproject 4.how will you get the requirements 5.why do we choose testing 6.how to export tc's and requirements to qc through add-ins
Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B
What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?
What are benefits of qtp?
Explain the concept of how quicktest professional identifies object?
Suppose I want fail that check point? How can you do that?
