Answer / 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

Answer / raj

May be solution i'm providing is not a DataDriven but it is
useful.

We can access the object property at runtime and then append
something in the property and then again insert into the object.

Like we have a text box amount having value = 10

So we can use

value1 =
Browser(".*").Page(".*").WebEdit("amount").GetroProperty("value")

value1 = value1 + 1

Browser(".*").Page(".*").WebEdit("amount").Set value1

Answer / cnu_thatavarthi

Question:did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods.

Answer: With out using datatables we can do the retersting using below methods
1. File System objects(Using note page)
2. Database connections(SQL, Oracle, MS Access)
3. Environment variables
4. Random numbers, Excel methods, Inputbox
5. Parameters(Actions and Test Parameters)...ETC

How can I change object description or check point values in qtp?

0 Answers  

---

If there are 100 checkboes in a page then how can we select 10th & 11th & 14th chexkboxes at once through descriptive programing in QTP using vb script. Please send the answers...

5 Answers   NTT Data,

---

What is synchronization? What are the ways you can synchronize?

0 Answers  

---

What is Optional step?

4 Answers  

---

I dont know how to configure non standard objects to standard objects in QTP9.2 can i have someone explain me in breify?

3 Answers   TCS, Wipro,

---

diff between winrunner and qtp

1 Answers   Wipro,

---

-->IF two TextBOxes are there in a "Form". -->A table contains some records which contains usernames & password.. -->What is the script we need to write using Descriptive programming concept...in QTP (simply DATA DRIVEN TEST SCRIPT OF QTP)?

3 Answers   CTS,

---

How to load object properties to object repository through scripting.give one example

7 Answers   IBM,

---

How to handle the exceptions using recovery secnario manager in Qtp?

2 Answers  

---

Could some one explain me how to create folder on the desktop from QTP?? This is an interview question

2 Answers   Clinical Soft,

---

How will you send values to a cell in a webtable using QTP?

2 Answers  

---

How to Analyze the Checpoint results by Text/Text Area Checkpoint?

1 Answers  

---