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 |
there are having 10 checkboxes..how can i check only first 5 check boxes by using descriptive programing..
how do check the links in a webpage ?
An object is created, i dont know the methods available for that object, i want to find methods available for that object and use the required method. How i can do this???
How would you parameterize the text field "Country" and the same "country" when it appears as combo field on other page with text field city and same with City combo field?
How to add multiple values in rows, under a single column of a run time datatable?
How to create runtime property for an object?
1) How will you associate SOR in Runtime? ( u had written 10 lines of code from 11th line u want associate what code u will write) 2) How will close n number of browser expect only one which is has to test? ( First tell me how will you identify how many browser are opened ) what logic u will use? 3) In web Table u want to click on link ( Link Name Mohamed ) you dont know in which row and column that link is there. how wil u identify and click on that link.
Types of properties that Quick Test learns while recording?
Reverse a string keeping the words in the string as it is. E.G. "Quick Test Professional" O/P "Professional Test Quick"
My project title is "DRUG Audition and research management" it comes which domain?
What is difference between WR and QTP?
HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is krishnuvk@yahoo.com