How open an excel sheet in QTP(not a run time )?

Answer Posted / pramod

Hello,

It asked for "not a run time " means "not in run time"
Why do you write all VB script code to open Excel in run
time.

It is simple. Click View - data table in QTP.
Right click on Data table window. Select File - Import.
Select the Excel file. that is it.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference btn risks & Therads in the Test plan documentation?

1592


wht type of User defined functions or Java Releated functions do we write in VB scripting

1833


What is the pros and cons between QTP and Rational Robot

3286


To which environments does quicktest professional (qtp) supports?

593


Why qtp always start action1 and does not start action?

607






How many number of actions possible in qtp?

606


What are the key points to create a framework in QTP for oracle forms?

1814


I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?

1567


What is the virtual object?

649


What is qtp window?

568


Client is able to provide budget..he want you to choose the automation tool for the web application? which one you will select ? QTP or Selenium ? what are the reasons?

1230


in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?

6331


Give me some real time point of way where exactly we can conduct audits?

1503


What is difference between Recording time object identification and Run time (Execution) time.

1007


Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?

1514