1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

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

Question Posted / priyareddy

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

How to Close all browsers in reverse order.

3 Answers   Marlabs,

some times we write user define functions.where we write main and sub program,how,where to insert the functions in qtp?

2 Answers   GE,

How QTP recognize the object??how to add objcts into object repository??

3 Answers  

how are environment variables used in real time projects (testing)?what answer should be given about this in interview.need real time explanation breifly?thnx in advance.

2 Answers  

What is the QTP test frame work?

3 Answers   IBM,




unable to get item from the combobox using descriptive programing. can any one give me the peice of code to schedule the booking from one place to another using DESCRIPTIVE PROGRAMING.

1 Answers  

I want to know what are QTP functons and what are VB script functions. What is the difference between them.When we have to use these functions.

0 Answers  

How to test login module with different username and password by using data driven testing in QTP?

0 Answers   HCL,

How to Analyze the Checpoint results by Standard Checpoint?

1 Answers  

what happen in object repository(shared)if we call an existing action from an external action ? and what happen in object repository(peraction)if we call an existing action from an external action ?

2 Answers   Covansys, Systel,

str="ramanareddy12345@gmail.com"to count alphabets,numarics and special charcters pls any one knows send to answer

3 Answers   Ziynx,

After i ran the Test in Batch mode i didn't get any results. Can any one let me know how it can be done?

3 Answers  

For more QTP Interview Questions Click Here
Categories