Sign Up Login


  1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

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

Question Posted / saranya

Answer Posted / saranya

hi manoj,

Try this. Even I am doing the same thing for my application.
First connect your QTP to QC. Then open the code which you
have saved in QC in QTP. Click on Test->settings(in QTP9.2
it will be File->settings) -> click on resource tab . In
that you can see a frame called DataTable. In that select
the option "Other Location" and click on the browse icon
beside that option. It will display you all the excel
sheets in QC. Select your Excel sheet. Now autopmatically
the excel sheet will be embedded to your code in
runtime.You need not include any code for this excel sheet
in your main code. (But do take care of the sheet names in
the excel sheet. It should be correctly mentioned in your
code.)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi, FOR 3+ QTP INTERVIEW, FOR EXAMPLE WE PUT ONLINE BANKING SYSTEM PROJECT IN OUR RESUME, IN PROJECT MANAGER ROUND...WHAT R THE MAJOR QUESTIONS ARE ASKED IN P.M? PLS TELL ME ATLEAST 10 QUESTIONS?.....AND IF POSSIBLE POST ANSWERS ALSO....

2675

What phases are involved in testing an application in qtp?

753

What are the views available in quicktest professional (qtp)?

804

Differentiate the type of test cases which can be automated and which cannot be automated?

789

How to handle the exceptions using recovery secnario manager in quicktest professional?

880

How to handle dynamic objects in quicktest professional (qtp)?

736

What is the basic concept of qtp?

764

How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?

4042

In an interview, what r the general questions asked in QTP? pls give me anwser to this question?

1630

What is quicktest professional (qtp)?

770

What are the different properties of an web object

1640

what is clean sweep?

1718

Hi. I have completed B.TECH(CS) , But I will go to "SECURITY CONSOLE OPERATING" [C.C CAMERA abservation]. IF interviwer asks " Why you choose this job ?" What we will say? urgent.........................urgent...........

1681

what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

1947

How you can find length of array in qtp?

762