How can we open an Excel sheet through the script

Answer Posted / arv

Try this out..It worked form me.. http://www.ibm.com/developerworks/linux/library/l-pexcel/

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Discuss the QTP Environment?

622


I used child objects to get the no of weblist present in the weblist.now i need to select the items present in each weblist ?How to do so

2254


Output values? i want a practical example

1309


What ate the Technologies supported by QTP?

641


How many types of parameters are there?

543






What are the advantages of parameterization ?

592


How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?

3574


Which scripting language used by quicktest professional?

526


After executing the script in qtp suppose i found some script execute successfully and found some error.So how to report the status for both (i.e pass and fail report)in test director. For "fail" We use "defect tab" in testdirector. But for "pass" how to report it to TL.what is the process plz anybody ans

1673


How many types of run modes are there in qtp?

584


What is the extension of the recovery scenario file in qtp?

538


Hi, I got error message as "object does not support this property or method: "Test.Actions" when i execute the following line of script on QTP 9.0 Dim qtApp, qtRep Set qtApp = CreateObject("QuickTest.Application") Set qtRep = qtApp.Test.Actions("Action1").ObjectRepositories Can anyone tell me where i am wrong.

1512


In order to select an automation tool for automating ur application, what r the things u need to consider? For eg i will go for automation; 1) When there is a lot of retesting and regression testing. 2) Return on investments. 3) Whether the tool supports the appln. 4)--------------, etc. Pls give me more number of points because my answer did not satisfy the interviewer. Very urgent pls

1442


How does qtp recognize objects in aut?

580


How to integrate the qualitycenter with qtp

1769