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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you close the second opened browser?

804


What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?

586


Why script error occur in between recording in qtp?

1770


What is an optional step in qtp ?

639


What is the difference between byref and byval in qtp?

589






When Recovery scenario actually starts while testing the application?

1548


Explain about business process component? types and usage?

1564


How can you identify the browser and its information using QTP script?

550


Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

1680


How to customize qtp?

614


Explain hybrid framework with advantages and disadvantages?

546


How many add-ins comes by default with quicktest professional?

554


While spliting an action in QTP 10.0 getting an error : "This Line is a part of Script Block.You cannot split the action on this line." how to re-solve this and split the script into actions?

1423


How to find the length of the string in qtp?

582


Explain about datafile/verification of date file when file is not available in local system?

2230