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
- 4 Answers
- 17074 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Where you are storing your script?
What is reusable action?
Suppose i have a script which is having 100 lines.I want to execute that script starting from line no 75.means first qtp should read the script from line no 75 how can u do it.
5 Answers Lehman Brothers, rsystems,
How to connect to the Database from QTP?
10 Answers DB, Thatavarti Technologies, Xchanging,
what kind of frame work you used in your last project?
What is the Diff between Image check-point and Bit map Check point?
How can i open 5 multiple browser at once through QTP VB script
What are software testing metrics
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
Hi I am new to QTP. can u please answer to my qus... suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query ... please please
What are the views available in quicktest professional?
Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers
WinRunner 
