Interested to Buy Any Domain ? << Click Here >> for more details...
did you perform retesting(DATA DRIVEN test) using functions
with out using datatable methods
how can you perform retesting using functions
- 3 Answers
- 6556 Views
- I also Faced
- E-Mail Answers
Answer Posted / amarendra kothuru
Generally, QTP exports uses Excel file for data
paramaterization.
Method 1)Prepare test data in Excel sheet and import into
QTP data table. Using DataTable methods, user can easily
parameterize data and access them through out the script.
DaTaTable Methods: Import, ImportSheet, Export,
ExportSheet, GetSheet, SetCurrentRow, SetNextRow etc...
E.g:
DataTable.Import "Excel file path"
testData = DataTable(columnName, Sheetname)
(or)
testData = DataTable(columnName, dtGlobalSheet)
Method 2)Prepare test data in Excel sheet. Instead of
importing Excel file/sheet into Test script, create an
Excel object in the script using CreateObject method. Using
Excel object methods user can able access data from excel
sheet.
E.g:
Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.WorkBooks.Open "Excel file path", false, false
Set currentWorkSheet = ExcelObj.ActiveWorkBook.WorkSheets
(1) 'first sheet
testData = currentWorkSheet.Cells(rownumber,
columnnumber).Value
ExcelObj.Application.Quit
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to prepared for first for the first interview?
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
write a script to verify links on any web page by using descriptive method by creating a description object (give a filter condition only link) ... need to verify expected like name by reading
How does quicktest professional identifies the object in the application?
What are the benefits of quick test pro(qtp)?
What are the advantages of a Hybrid framework?
What are the data types in qtp?
Explain in brief about the quicktest professional automation object model?
How to use checkpoints in qtp ?
Which functionalities of QTP used in banking project?
Discuss quicktest professional (qtp) environment?
Why script error occur in between recording in qtp?
can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?
How to recognise the webelement and verifying that webelement is enabled?
What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this
