How can we import a Open Office excel file in QTP
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / udham singh
u cannot work on any excel sheet in QTP if it is already opened.first u should close the excel sheet then only u can import it 2 QTP and can perform other operations by QTP.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / lakshman
we have cammend fot these
Datatable.import"path of the excelfile"
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / prem
1)Activate the menu item view-->select the option datatable
2)right click on datatable file-->import from file click ok
3)select the desired excel file from location
4)click on open
| Is This Answer Correct ? | 2 Yes | 9 No |
How to create a standard checkpoint ?
What are the 3 main stages involved in testing with qtp?
can onyone tell me how to comapre the output of two different Data Bases in QTP?
WHAT IS ENVIRONMENT VARIABLES?
How to Test Dynamic links ?
I want to open a GOOGLE page without recording a test in QTP.Can any one answer me?
how do pass parameters from one action to another action
Please explain the role of Regular expression in QTP
In a web application , there is a table of rows and coloums , i want to pickup the 1st row and 3rd coloums name (not data)how can any one explain
Describe how Smart Identification is used
write a qtp script to verify that the business price is twice the economy price in flight reservation window
How to display the first 3 letters in these "ABCDEFGH" using qtp script?