Answer / uday kumar_anem

We can import or export the data from Excel sheet in 2 ways.
1. by using Datatable.import("ExcelFile")
Datatable.export("ExcelFile")
2 Place your mouse over datatable in QTP and right click ->
File -> Import File /Export

Answer / dixit

her i want to add some thing
if you want to import particular sheet then you can use
ImportSheet method

DataTabe.ImportSheet("path of Excel",Source Sheet,Dest
Sheet)

Answer / ramu@sunnys

yes,we use datatable.import for import data and
datatable.export for export the data

Answer / ramu@sunnys

yes,we use datatable.import for import data and
datatable.export for export the data

In QTP, What is Global action and Local action?

0 Answers   Virtusa,

---

can test automation improve test effectiveness?

0 Answers  

---

QTP script is not working on other's machine..

0 Answers  

---

Hai anyone please "Explain about Framework in QTP?"

0 Answers  

---

QTP9.1 does not support to text checkpoint in Windows application? Is this correct? If this is correct, what is alternative for Text checkpoint?

2 Answers  

---

how to write script in qtp(vbscript)..i mean with out application deployed..and how to call script1 into script2?

2 Answers  

---

Suppose u run ur script today and it is working fine ,nobody has changed the setting and all.u r the owner for the script. But when tomorrow I ran the same script again it got failed and It didn't able to identify one object. Can you tell me what would be the reason for this

4 Answers   L&T,

---

how can we merge the object repositories?is ther any option in qtp to merge the object repositories if we have two or three object repositories?

6 Answers   IBM,

---

your doing one project testing then how u know itis wheather web based application or windows based application?

2 Answers  

---

Hi, I have a login page. To login in that page I need to have a valid username and password, which is stored in database. I imported that table to my DataTable in QTP (Global sheet). Now I need to write a code in qtp so that I can login only with valid username and data. my condition is : I want to get username and password from inputbox(which i did) and click on login button- which should verify the datatable for username and password and if value is present only then lofin else stop the testing. DataTable contains columns : LoginName and Password Code: Rowcount= DataTable.GetSheet("Global").GetRowCount msgbox "RowCount= " &RowCount,1 CurrentRow= DataTable.SetCurrentRow(1) Do Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct l00$ctl00$UserName$ctl").Set DataTable("LoginName",1) Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct l00$ctl00$Password$ctl").Set DataTable("Password",1) Browser("").Page("").Frame("Frame").Link("Login").Cli ck CurrentRow=CurrentRow+1 Loop Until CurrentRow>Rowcount Can anyone help? Thanks, Priya

3 Answers  

---

A web Page has a webtable with four columns and four rows. The first column is of ID and has values of 100,100A,A100,100y Find out the number of rows whose ID starts with 100. Similarly the last column is 'number of links'. Each row in the last column has values like link1,link2,link3 etc Find out the number of links where id is 100

1 Answers   Virtusa,

---

How we can add actions in the test using QTP?

2 Answers  

---