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??

Answers were Sorted based on User's Feedback



Can anybody give the script of below things. 1. Add sheet 2. Adding columns 3. Set the values in ..

Answer / 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

Can anybody give the script of below things. 1. Add sheet 2. Adding columns 3. Set the values in ..

Answer / saritha

hi
data table methods:
1.Add sheet: adds specified sheet to runtime data table
syntax: datatable.addsheet("sheet name")

3.set currnt row method;
sets the specified row as the current row

syntax: datatable.setcurrentrow(rownumber)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More QTP Interview Questions

Hey friends i m facing a problem when i m running my script in qtp it waits for about 5-10 secs before starting execution why it is so can any one solve my problem .Previously it was running fine

1 Answers  


Are Shared ORs read-only?

0 Answers  


How will internal and external links be validated and updated? how often?

0 Answers  


Hi, My problem is as follows. I recorded a script that created Object repository of each action i recorded. But later I added one more step (which was to enter data in a textfield) into the script through expert view. But as no repository for this newly added step exists in the test, my script fails. So please help me to sort this problem that how can I create object repository of a new step in an existing test. Thanks everyone

1 Answers  


.mtr ( modular test repository or mercury test repository) plz give correct answer??

3 Answers  






Are You using any frame work? What is that? Explain about that.

4 Answers   Wipro,


hi i have one isuue on selecting webcheckbox .there are 15 wecheckboxex i want to select every time 9 th one how can i select plese help me regards balaji

4 Answers  


How to retrive the property of an object?

5 Answers  


what type automation is fofollowed in the project?

1 Answers   Satyam,


we have 10 actions in out test how can we convert 9th action is main action ? how ?

5 Answers  


How to Compare two database tables by using QTP?Please give me code details.

1 Answers  


hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.

0 Answers  


Categories