did you perform retesting(DATA DRIVEN test) using functions
with out using datatable methods
how can you perform retesting using functions
- 3 Answers
- 5934 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
Does any one worked on JIL Emulator , Testing with QTP(automation). Trail Version of QTP is not identifying the child objects of JIL emulator, Can any one help me out ,
How you can decide which type of object repository you have to use?
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
Explain how you can find length of array in qtp?
what is the difference between modular framework & datadriven framework
What is the purpose of loading qtp add-ins?
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
What is the file extension of the code file and object repository file in QTP?
iam have done mba(finance)in 2008. in 2008 one reputed consultancy came off campus interview our institution. i got job as "manual test engineer". now iam working as "manual testing engineer". now my problem is when iam going interview the interviewer asking like " ur mba gradute how can u get job in test engineer." this question i have faced every interview. iam explaining how iam getting job. but they are not trust me". pls tell me answer how i am giving relavent ans.. this is my mail id y.ramana84@gmail.com
What r the different filters in defect in quality center
what is the frame work in J-meter?
What are the key elements available in test result window?
How many scripts did you have?
What is action split and the purpose of using this in qtp?
What is the process of synchronizing qtp and aut?
