Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Define virtual object?

1159


What is the use of running the scripts in Hidden-mode in UFT?

1227


if our qtp vb Script may be Currepted then What we want do?

1916


Hi, Hope you viewers are doing fine with good health. What are the steps and connection parameters to connect to Oracle db ? Can you connect with just the Oracle client or Oracle XE ? Cheers!!

2995


I want to do QTP Certification what is the pattern of Question paper.

2173


What are the advantages of Object Repository?

1099


what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana

1943


what is key word driven frame work ? why it is called like that ? what is the diference between keyword driven and data driven frame work ?

2000


1--How many functions u develop 2--What is an array 3-- where is ur server 4--U involved in unit testing 5--how ur test the background colour using QTP

1966


Define Environment Variable in UFT and its uses?

1082


How can I check if a environment variable exist or not?

1050


I want to capture data(using keyword) from msdos application using QTP?... Below is little work i could do on it... /* Set app=CreateObject("Wscript.shell") SystemUtil.run ("C:\Users\Agent\Desktop\pumpsim\PUMPSIM.EXE") Window(“PUMPSIM.EXE”).Activate wait(3) app.sendkeys "N" */ Thanks in advance...!!!

1867


What are the common defects found in your project? (in qtp interview)

2065


Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.

2841


Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.

2170