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

I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?

0 Answers  

What is a data driven test in qtp?

0 Answers  

What are the five challenges you faced in QTP?

0 Answers   CTS,

where did you automate in your project?(please tell me example senarios)

2 Answers  

Is it possible to test Flat file using QTP? I have two file- first file is Input file and second file is output file. Input file has Format like first 2 field is record type, next 10 field is Description. Output file also has format. I want to check this file format using QTP. Is it possible?? please reply with example.

2 Answers   Wipro,




i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click

0 Answers   Rogers,

Waht is Test Report , What it consists?

2 Answers  

Hi Friends, Iam Beginner in QTP and i want to Try the software QTP. I checked the mercury site for QTP Trial version and i found QTP 9.0. The thing is that it supports windows 2000,Xp but not windows 98.And Iam using Windows 98 onlu and it's not possible for me to upgrade to windows 2000. Pls. guide me how to get the trial version of QTP which supports windows 98 Operating System The version may be 6.5 is ok for me.Thanks in Advance

2 Answers  

What is Environment Variable and when we apply this in QTP?

3 Answers   TCS,

How will u test content of an web application with out using chechpoints in QTP 9.2?

3 Answers   CTS,

What Folder Structure following in Keyword Driven Frame work?

0 Answers  

Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?

0 Answers   IGI,

For more QTP Interview Questions Click Here
Categories