Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am runnin..

Answer / karishma

got to options and select folders tab and give path of the
folder where the excelsheet is present in QC
and then try out this:
x=PathFinder.Locate("Results.xls")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook2 = objExcel.Workbooks.Open(x)

Is This Answer Correct ?    4 Yes 1 No

i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am runnin..

Answer / 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

i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am runnin..

Answer / manoj

with that code we can open a new excel or even open an
excel that is saved in our system
but i want to open an excel (which is saved in Mercury
Quality Center ) during run time.

is there any piece of code to download the excel from
Mercury Quality Center to local machine during runtime?

Is This Answer Correct ?    1 Yes 2 No

i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am runnin..

Answer / giridhar reddy

Hi
try this one, I am not giving you the whole syntax because
if you start analyze you will get more information on this
right? thats why...

SystemUtil.Run "excel",""

if you have any doubts let me know

Is This Answer Correct ?    2 Yes 12 No

Post New Answer



More QTP Interview Questions

HI! I have completed my testing course in 2008. but now am working in banking sector as a data analyst and i want to move to an IT based company but am unable to understand whether i have to complete the testing course again and try for a job .

1 Answers  


How to find duplicates in an array and remove them efficiently?

2 Answers  


By using QTP can we record any log files written by the application which is in execution?

0 Answers   Ordain Solutions,


What is the difference between the keyword view and expert view?

0 Answers  


What are the problems / difficulties faced when you used Smart Identification ?

2 Answers   Keane India Ltd,






HOW do we find a datasheet when there are 4 datasheets in data table.this question was asked by covansys interview.

5 Answers   CTS,


How to change the Default synchronization method time and where?

4 Answers  


I Scheduled a QTP Script on remote desktop. Script is going to failure,when remote desktop connection fails.I have to open my remote desktop untile the scripts exection completes. If I disconnect my remote desktop connection, script is going to fail. Could you please any assist in this?

2 Answers  


What is test object model in quicktest professional?

0 Answers  


write script for , launching fr window,login and create 5 elements array and store 5 order numbers inthat array? and open order by using order no.s in array and find out maximum tickets booked by which order?

1 Answers   TCS,


How to use actions in qtp ?

0 Answers  


Hi, is it possible for recording shortcut key during record session? The application on which I am working is web based application. This application has several shortcut key associated with menu option. I have succesfully recorded all menu option but unable to record shortcut key.

0 Answers  






Categories