How can we import a Open Office excel file in QTP
- 4 Answers
- 9687 Views
- I also Faced
- E-Mail Answers
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 |
when to start the automation?
Explain types of descriptive programming?
Define object spy ?
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..
what are the files created after executing QTP script file, please specify the file names with extensions
my assignment is,how can i differentiate between readed & unreaded mails in my inbox ?, since for both readed & unreaded having same properties for both test objects &run time objects
Tell some commonly used Excel VBA functions?
Explain the concept of object repository and how QTP recognizes objects?
How will u integrate oracel with QTP?
can anyone proide me reading material on svit00ef27@yahoo.com please thanx in advance
How can we merge two repositories? Can we merge two differnt rep. I mean 1is peraction and other shared
4 Answers Tavant Technologies,
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
WinRunner 
