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
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 |
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 |
what r the main attributes of test automation?
what is the syntax or command in vbscript to display user message example i want to display "welcome to QTP".
What r the diffrernt file extentions in QTP?
Hi every body, I am new to QTP.pls help me if anybody knows the solution. Here is my doubt: I have 3 excel sheets in my local drive out of which one is password protected and i want to get the data of all these xL's either by importing or by reading the data finally i have to update this data in the website.(and the site is secured site) I tried by importing all XL"s one by one but couldn't do so. plss send me the code or atleast suggest me the approach. Thanks in Advance Padmaja
How to retrieve the data from database?
Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?
What are metrics and matrix?
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
Hi Recently I Attend one interview .The intervier ask on Question in QC 9.2 . The Qus was while ruuning the Batch RUNS scripts in test lab if defect will comes .The defect automaticly wants to genate . How to Configure in QC . Thank You Balaji
In real time ,How to run all scripts in QTP? i,e in projects
What is the use of "Define new test object" in QTP 9.1 When should we use? Explain?
Can any one tell the different properties and values of differnt objects like Browser,Page,link,webedit,webcombobox,webradio botton,webcheckbox and web button.Because I am facing a lot of problems in interviews with Descriptive Programing.I never worked on web Application...Pls help any one as soon as possible....