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
- 6748 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
Through array we can execute the testcase how ? give me example
How to modify object property in qtp ?
How you know that a test case is a regression test case
I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...
Explain the types of properties that quick test learns while recording?
How to remove the associated function library?
What are the different recording modes?
how do i know how to use tools
Hi, Hope you viewers are doing fine with good health. What are the steps and connection parameters to connect to Oracle db ? Can you connect with just the Oracle client or Oracle XE ? Cheers!!
Can UFT be connected to Quality Center? If ‘Yes’ brief the process or steps.
Does QTP record on Objects created on XWindows Environment?
how u will evaluate the tool for test automation?
whare exactly we have to use functions and sub routain
1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?
What the differences are and best practical application of Object Repository?
