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

what is the process to follow between writing the test cases & then atomating it?

1 Answers  


what is the script for keyword driven framework in real time?plz its urgent

1 Answers   Accenture, CTS,


Explain different types of action in qtp?

0 Answers  


How you know that a test case is a regression test case

1 Answers  


Without QTP (or any Testing tool) can we able to test the GUI part of the Applications. for Example generating the Scripts in Notepad and Executing them Using VB. Is it Possible to do so.. Correct me if iam wrong some where.

8 Answers   Microsoft,


if there is a web table of having row and colmns.a button is placed at 2nd row's 3rd column which is worked for both edit and delete..how to write script for the button to test both operation on the web table using desriptive programing.. plz help me on script wheather using getroproperty Q2)what is the command for taking valiue from a web table in qtp

6 Answers   Logica CMG,


Discuss the QTP Environment?

0 Answers  


now a days which one is using all companies for qtpscript a)Object Repository based script b)Descriptive program based script c)BOTH

1 Answers  


i am trying to automate yatra.com,in that site, when i go to automate the Leaving from field showing as a WEBEDIT, but when i enter 1 or 2 char, it displaying dropdownlist, i try to use keyboard automation to select the item from that list but it is not possible, can anybody help he. Thans for posting the Answer

0 Answers   TCS,


Where we write the FUNCTIONS, in Expert view (or) in any textfiles like Notepad and save it in Library functions folder? How to cal that functions to our script? How to save that functions to Function generator?

3 Answers  


How to Start recording using QTP?

1 Answers  


How you are maintaining shared object repository in your team or your project?help me plz

1 Answers   CTS,


Categories