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
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
Give me some real time point of way where exactly we can conduct audits?
if numbers are always changing write a script for that
What is environment variable in qtp and why to use it?
If you are testing a web application then what will you test in that application?
What is a quick test professional?
What is the default add-ins in qtp?
Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?
Explain different types of checkpoints?
If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?
What is the descriptive programming?
There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code
What is Associate Repository in QTP 9.2 ?
Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)
Tell me about qtp?
Give the syntax to import/export xls into qtp.