Can anybody give the script of below things.
1. Add sheet
2. Adding columns
3. Set the values in that columns(In the rows)
4. Close the sheet
5. How can we create 3 sheets in one Excel sheet??

Answer Posted / srikanth

1.Datatable.AddSheet("Global")
2.Datatable.GetSheet("Global").Addparameter("User_name")
3."srikanth"=set Datatble("User_name", dtGlobalSheet)
4.Datatable.close
5.Datatable.Addsheet("Sheet1","Sheet2","Sheet3")

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you find the current time of the remote machine using QTP script?

601


Functions call by reference and call by value. i want the diff b/n these 2 and how will be the script for this?in which situation we use these 2..?pls explain me clearly

1254


Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?

561


If I change the property value at runtime is it effect is object repository?

611


How to execute a winrunner script in quicktest professional (qtp)?

521






For example you are checking bit map check point before coming to the results. How can you say it is passed? Or failed? Anyways?

618


What is synchronization? What are the ways you can synchronize?

653


How would you export a script from one pc to another in qtp?

663


How many types of actions are there in quicktest professional (qtp)?

538


how can we do the frame work in qtp

1606


Which environments are supported by hp qtp?

602


Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop.My scenarios is like that,it should contain following steps. 1)Automatically it should click on start and then on remote desktop connection. 2)it should enter the IP address and then connect to remote desktop. 3)and then it should be able to record the application in remote machine and then run it also. Can somebody tell me how to record the application which is in remote machine.

1491


Can launch two instances of qtp on the same machine?

583


How QTP identify the system time that's changes every seconds?

598


How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined

1467