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

what is On Error Resume Next ?

4 Answers   Accenture,

---

How to check and display a particular word from a paragraph?

1 Answers  

---

what r the 3 basic factor on which we determine to perform automation

6 Answers   AppLabs,

---

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

7 Answers   IBM,

---

When i used this below script to insert value in the Datatable... At run time it was inserting the given value in the specified column, But after execution all those inserted values were cleared automatically... datatable("column name",sheetid)=value

1 Answers  

---

Give me some scripts for 1). checking webpage links (counting links,opening web pages,counting child elements)

2 Answers   CIL,

---

Can U Explain about QTP tool from older version to latest version also its differences?

0 Answers  

---

Hi Friends, I have an application that is having some options to choose. While doing business transaction I need to select one option among from available options. But here the thing is, we won't get one option which we've chosen already and the available options will get automatically from the system with time basis, moreover each and every option having with various label names respective to that option. So obviously if I run my recorded script will automatically gets fail, even though it got pass at first time. Could anyone please give me appropriate solution for this. I would be greatly obliged with you if you give the solution as soon as possible.

1 Answers   Zensar,

---

how to explain a claims and insurance project?

0 Answers  

---

how will you check how many members visited the website www.infosys.com?

0 Answers   Logica CMG,

---

How to check the value for variables during run time. Pls anybody can give the answer.. Thanks in advance...

4 Answers   Navis,

---

give me the code for check point for validating application

1 Answers  

---