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

Does QTP run in any environment?

694


Can you write a script to check if the folder exists or not?

601


How to creating an output value using quicktest professional (qtp)?

662


When you open QTP, how many sheets you can see?

739


What are the key elements available in test result window?

720






What are the 3 main stages involved in testing with qtp?

644


How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks

2859


We stored into the objects OR and then write the scripting

1630


Explain how Selenium is different from UFT?

783


Explain types of output values?

647


1. wat are the main diff b/w QTP 8.0 AND QTP 9.2 ( not user interface) 2. wat is the meaning of Keyword in keyword driven frame work? 3. how u will handle the unknown errors while exucution. (not recovery scenario)

1840


Hi I have exp in manual testing and planning to move in automation testing qtp(9.2).So can help me how to automate customer relationship management tool using qtp and vb script this tool already developed so how can I test it whatever maintaining by development team like documents,various options just give the whole life cycle thanks in advance

1631


How do you check ticket cost and ticket number in flight application?

676


How do you send email with attachment from outlook using qtp ?

646


how do we know whether all objects are stored in the object repository or not? how can we know if a particular object is not stored in the repository?

1410