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

Suppose Object name was changed in the application in the second build.I have just modified the name in the Object repository as changes in the Application. Is it possible to accure changes in the script accordingly? If so Suppose I am calling the script through function, Will the changes affect in the script(which is in the function)automatically? If not affected, tell me the solution,How to handle this. How should I change the object property name while using functions

4 Answers   Livetek,

---

Can a function return a dictionary object?

2 Answers   CG, Semantic Space,

---

how i can delete the excel process for the task manager using QTP

2 Answers  

---

i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am running this script from QC itself

4 Answers   TCS,

---

We are using the QTP version 9.0 where we want to call objects from global repository for a particular function at runtime for increasing the performance of framework.We are actually looking for loading the objects under test (OAT) dynamically when script runs and would like to unload the same once the execution of the script is completed.

2 Answers  

---

can any one say that where we can download the QTP trail version ??????????

0 Answers  

---

what is profile tool?

0 Answers   ITC Infotech, TCS,

---

In our application (Web based application)we will get a pdf file and we have check a particular text in that pdf. Can any one tell how to check text in a pdf file. In the same pdf file it generating some links and I have to click that links. QTP unable recognizing that links, even id did record and playback qtp does not generating any script. Can any one help me….?

6 Answers  

---

What are test settings and global settings?

0 Answers  

---

What are the advantages of QTP over WinRunner?

5 Answers   CTS,

---

What is FRAME WORK? How many Frameworks can QTP supports?

4 Answers  

---

Hi can anyone pls suggest how to fetch username(system login name)and system name in to qtp.I am not using TD or QC.Thx

5 Answers  

---