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")

Please explain the role of Regular expression in QTP

0 Answers  

If the web applicatoin takes navigation time above 2 hours to dispaly next Web page then how can we synchronize the QTP with Appilication Under Test

4 Answers   TCS,

What is test harness?

2 Answers  

hi all here i have tab named "Workbench" By clicking on "workbench" tab.it displays 4 tabs like below workbench common cargo commercial charter "common" tab have 10tabs inside,"cargo" tab also haveing 15 tabs inside and remaining two tabs also having few tabs inside. when clicked on "common" tab.it displaying the script like tab("workbench").select"common" if i clicked on "cargo".it displaying the script like tab"workbench_2").select"cargo" if i clicked on "commercial".it displaying the script like tab"workbench_3").select"commercial" if i clicked on "charter".it displaying the script like tab"workbench_4").select"charter" I have used a "FOR LOOP" for common,commercial,cargo,charter tabs.it was stopped at second tab SO, CAN I RECOGNIZE "WORKBENCH_2,_3,_4" AS A SINGLE VARIABLE if not, can anyone plese help me to solve this

0 Answers   Livetek, NIIT,

what is meant by Utility object and utility functions?can u all pls explain these clearly.

1 Answers  

what is qtp automation framework, what is the purpose of the framework and which folders included in this framework pls tell me with brief description

2 Answers   PSI Data Systems,

How to retrieve data from application objects?

1 Answers  

using descriptive programming how to close all opend browsers?

7 Answers   Satyam,

What is checkpoints for quicktest professional?

0 Answers  

hi i want write code for "test engineer" in this i want write reverse how ca plz let me know through script

4 Answers  

How to associate function library at a run time?

0 Answers  

i this is balaji from chennai i have 4 yrs exp in testing and my qualification is bsc computers i completed in correspondace in which companiies accept the correspondace plz let me know

1 Answers   Accenture,