How can we import a Open Office excel file in QTP

Answer Posted / ganesh raj

Set excelObj = getObject(, "excel.Application")
Set openExcelWB = excelObj.ActiveWorkbook()
exPath = openExcelWB.path
openExcelWB.close
excelObj.quit
excelObj = nothing

Data table.Import exPath

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give me detailed theritical explanation about keyword driven, hybrid framework, environment variables, hybrid frame work

1438


how can i pass a "cript"as a parameter in to a function

1454


Can anyone tell me how i used QTP 9.2 use for GIS based S/w with an example?

1682


Explain the qtp test phases.

614


whare exactly we have to use functions and sub routain

1842






what is the difference betn QTP 8.0 AND PREVIOUS VERSION

1949


Why do we use breakpoints in QTP?

580


in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?

6318


Can we record an application running on a remote machine using qtp?

719


Can you brief the hurdles you faced during Automation testing?

575


hi i have completed my b.tech in cse stream. now i am working in an organisation in testing department. i want do sap course but i dnt know which module will boost my career can anyone suggest me which is good for my career

1923


i have asked earlier only one question how to test web application using QTp plz send me the answer quickly

1655


Explain how Does Run time data (Parameterization) is handled in QTP?

555


Write a script to verify font style and color of a windows object using descriptive programming

831


How to find operating system information using the qtp script?

582