how do we add a new sheet to data table in QTP?
- 7 Answers
- 38359 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aparna
In two ways we can create data table
1)By creating different actions in test we can create data
table for that action.
2)Dynamically we can create data table as
datatable.addsheet <sheet name>
The created sheet called as virtual sheet and we can call
it in any action by using
datatable.getsheet "sheet name" method
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / raavi
The created shhet in virtual sheet then we can cal any
where in the program
Datatable.getsheet"Sheetname"
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / kumar.c
'Add New sheet in Datatable
Set a = Datatable.AddSheet("Kumar")
msgbox a
| Is This Answer Correct ? | 12 Yes | 10 No |
Answer / k. chandra sekhar
a) In QTP add the new sheet is possible in two types. They are
b) In Different action: Here possible to create the any
actions of recording
c) And condition of new sheet in data table: Here give the
syntax then create the new sheet. That is
d) Data table .get sheet “sheet name”
e) The above method is call virtual method
Hi This is K.Chandra Sekhar
If any query then send to mail ndra_143@yahoo.co.in
I am taking the testing projects FAQS class
Call 9246540049/65880049
In Hyderabad
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / balaji s
Datatable.Addsheet "Sheet1"," "
Instance purpose i am using the sheet name as "sheet1" if
the user wants to use some different name then they can use
it.After adding the sheet adding a value in the column is
necessary so i add null values for that
Regards,
Balaji S
9894207910
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / noor
To Add a new sheet first we need to give the reference for
the sheet i.e
Datatable.getsheet("sheetname")
//sheet namehere can be global or local//
then add this statement
Datatable.addsheet("sheetname")
If you want to give the column name and its value include
Datatable.addsheet("dtglobal/Action1")"Username","ABC"
Thanks.
| Is This Answer Correct ? | 0 Yes | 5 No |
Hi All, I am 4 yrs experieced in manual testing and new to automation tool QTP. Iam trying to learn it thru online and material i have.I am able to understand but unable to trace out which method or function to be used where necessary in VB Script. How come we know the functions or methods to be used to open a window when clicking on button or so...Pls suggest me.How can i proceed further to apt VB Script.
Tel me what was the automation testing process you followed?
Where virtual objects stores results?
what is defination of intergration testing?
An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))
How many types of status are there?
what is action in QTP?
how can i do QTP Certification can any 1 tell me . How 1 approch and who to approch
How to export quicktest professional results to an .xls file?
what do u mean by test harnesses in qtp?
How to recognize and read data from pdf file using Descriptive Programming in QTP?
What is use of object spy?
WinRunner 
