Answer / sunita

1.goto QTP
2.datatable.Addsheet "xyz"
3.datatable.import"C:\a.xls",1,3
1 is source sheet of a.xls
3 is destination sheet of xyz
a=datatable.getsheet(3)

Answer / pandu

Yes Siva, The solution what ur given is correct.

Hi Niturao, The Excel sheet contains manual test cases. so
QTP don't undestand what ur writen in ur manual testing. If
it is a VB script u can download from qtp and run not
other. So u want to prepare the test scripts in QTP
separately. like what siva given. or simply u can record
tests.

Answer / niturao

thanks a lot siva for the explanation.
thanks pandu

Answer / siva

Sunita's Discussion was something about Importing some test
data in to the data sheet of QTP by that data we can
conduct RETESTING by a process called parameterization (or
else we can create For loops...) but Nitu Rao's Question is
about test cases, they were already written in Excel sheet
and importing in to QTP test pane to automatically generate
script for those test cases....
The answer could be...
1) Let me take a test case for Login, written already in
Excel sheet===Enter valid inputs in to User Id and Pass
word. enter "ok" button....this is the test case and let us
not worry about the Actual and Expected values and so on
2) Let me "write" the script for the same scenarion of
Login:
if the login is a dialog box...then
Dialog("Login").WinEdit("Agent Name:")Set "niturao"
Dialog("Login").WinEdit("Passwrod:")Setsecure "*****"
Dialog("Login").WinButton("OK").Click

here what I would like to emphasize is We must "write" the
Script in QTP or the script can automatically be generated
only during RECORDING.
so, if you import test cases in Excel sheet I THINK IT
WOULD NOT WORK. only test data can be imported.
I think you got it
sivaprasadnunna79@yahoo.co.in

How u prepare Test result summary in QTp?

4 Answers   CGI,

---

Write a script to verify font style and color of a windows object using descriptive programming

0 Answers  

---

How to make an Action as reusable?

1 Answers  

---

How to get Traceability matrix from TD?

0 Answers  

---

hi all i have qtp 9.0, Active screen is not working means after recording script snap shots not displayed in Active screen window. i have all ready check all setting means Tool...>option...>Active screen...>Default Level button is disabled. Is there other setting is remain to set Pls help i m new for qtp

1 Answers  

---

---

There is a very good institute for Automation Testing using QTP.For more details please visit jbslearnings.com.

1 Answers  

---

one ok button and one text box is there.when i click on ok button in that text box one no. will display from 1 to 100 randomley.if that is not 100 when we click on ok button again ,again another text box ll created with another no. we will continue this till the text box created and displays 100.and when its 100 ok button should disabled. remember thet no will display not seriely ,it displays randomley,and each time new text box will created.

6 Answers   ADP,

---

What does it mean when a check point is in red color? what do u do?

1 Answers  

---

what is Property......End Property loop? how to write sript for it in QTP

0 Answers  

---

Extract a word from a sentenece?

5 Answers   IBM,

---

What will be the test script in QTP to test a ComboBox where a user has to select more than two items????

8 Answers   L&T,

---

While writing script using For Next Statement in QTP, I try defining the variable in Lib File I am getting syntax error whereas if I use the variable in script file, the script works fine. Can anyone help me in finding the reason behind this?. E:g Dim intStartRow (Define in Lib File----- say abc.vbs) Dim intRow (If I define this variable in Lib file I am getting Syntax error where as if I define in the script file ---- say xyz.mts the script works fine) IntStartRow=2 For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count ‘Some Code here Next

1 Answers  

---