Interested to Buy Any Domain ? << Click Here >> for more details...
How can we open an Excel sheet through the script
- 8 Answers
- 44596 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 to handle dynamic objects in quicktest professional (qtp)?
What are the trigger events in qtp?
I have some real time based question.. 1.what are the challenges you have faced in your current project. 2.what are the bugs you found in your current project. 3.what are the strategies you follow to convert manual test cases into automation test cases. 4.how QTP identify two different browsers. 5. When you create a function library and share object repository what are the problems you have faced 6. How to solve the tool tip problem 7.what are the interesting bug you have found in your current project. 8.what is your daily work as a automation test engg. 9. how to create a weekly status report. 10. how many test cases you write,review and execute per day. 11.what are the uses of SQL in automation. 12.How to retrieve the data in html through vb script. 13.If application is very slow how to test the application in qtp.
Where we can use the analog mode and where we can use the low – level mode?
How to recognise the webelement and verifying that webelement is enabled?
Why we load add-ins in qtp?
Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?
Hi, Can anyone please tell me how to connect the QC with QTP using QTP script? Thanks in advance
In QTP can we feed the out of one browser(internet explorer) as an input to the another browser(mozilla firefox)? If yes explain how to do it with an example.
Hi! My OTP script has several bitmap checkpoints included which I check in the test results xml file. The test is for SAP 4.7. I need to save these bitmaps to files or at least export them to the html file using the export function in the test results viewer. Could you please help me with this problem? Thank you in advance! Best regards, Peter
Explain building blocks of the bpt framework ?
What are the views available in quicktest professional (qtp)?
What test cases can you automate using QTP?
What are output values and why they are used ?
Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.
