Answer / uday kumar_anem

If you want to open Excel sheet using QTP, follow the below
script:
Dim objexcel
Set objExcel = createobject("Excel.application")

Set objWB = objExcel.Workbooks.Open("FileName")
Set objWS = objExcel.ActiveWorkbook.Worksheets("SheetName")
objexcel.Visible = True

Answer / sreekanth chilam

HI All,

Try for this three ways given below :

1.
SystemUtil.Run "excelsheet path"

2.
Dim xl
Set xl=CreateObject("Excel.Application")
xl.Visible=True
xl.WorkBooks.Open "ExcelSheet path"
xl.ActiveWorkBook.Save
xl.Application.Quit
Set xl=Nothing

3.Dim xl
Set xl=CreateObject("WScript.Shell")
xl.Run "Excel.exe"

Answer / tvsramakrishnachowdary

Hi Chandra sekhar...

Every time ur approach is abt recording...pls try to avoid
that..it will creates u prob in the real time..ok...

follow following code...
-----------------------------
set xa=createobject("excel.application")
set xb=xa.workbooks.open("d:\sample.xls")
set xs=worksheets("sheet1")
val=xs.cells(1,1).value
msgbox val

NOTE:here (1,1)--->1st row,1st column

Answer / arv

Try this out..It worked form me.. http://www.ibm.com/developerworks/linux/library/l-pexcel/

Answer / mukesh raghav

We can open a excel sheet from the given location.
First you write a script in ksh shell and mentioned the
actual path of the sheet and try to run your script.

Answer / bhaskar pothuri

This question is related to automation. As an example we
can open an excel sheet in QTP using the library functions
available in the VB scripting.

Answer / k.chandra sekhar

a) In QTP data table have two types of the Excel sheet.
b) If the extra Excel sheet wants then you create in
the data table window in QTP. This facility is possible in
QTP data table window.
c) If you want script to excel sheet then start the
record and open the one new excel sheet then stop the
record after check script. That is the script of the excel
sheet.
d) Once do this function of the excel sheet. if you
get the scripts.



My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send the mail

Answer / srikanth

InvokeApplication("C:\Documents and Settings\All
Users\Start Menu\Programs\ExcellSheet")

can any one explain with an example how to test Web application using qtp

3 Answers  

Explain about datafile/verification of date file when file is not available in local system?

0 Answers  

what is frame work of qtp?

4 Answers   ITC Infotech, KPIT,

How should i get name of the screen? Ex:There is a "submit" button.If i clicked on the submit button it opens a screen. I want that screen name.How can i get that screen name I dont have any property regarding that screen. If suppose we cliked on the screen , Then QTP captures the screen properties then i can get the screen name by using GETROPROPERTY But i want the screen name without clicking the screen. ("I am using the "settoproperty" for Second screen by using fist screen properties") Please tell me anyone

3 Answers   Livetek,

1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible

0 Answers  

I have thousands of links are there, i want check each and every funtionality of link by using descriptive programme, retrive link name from excelsheet then operate in application. Please anybody send me model script

1 Answers   Oracle,

What is the difference between Datadriven and Parameterization?

8 Answers   Ordain Solutions,

How to add check point?

2 Answers  

Difference between image checkpoint and bitmap checkpoint

4 Answers  

In how many ways we can add check points to an application using QTP.

2 Answers   Infogain,

Hi , I am new to VBscripting, My requirment is to write a vbscript to read a row (which has coloumns like Description, Code, date(DD/MM/YY), hours etc) and export these feilds to a Website and then click on Submit Automatically on that web page. This it should do for all the Rows in that excel file. Any help is much appriciated Thanks Shalini

2 Answers   TCS,

how do u handle an object with out name in our application using QTP 9.2?

0 Answers   CTS,