Interested to Buy Any Domain ? << Click Here >> for more details...
How can we import a Open Office excel file in QTP
- 4 Answers
- 11195 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 |
how to count the word "IS" is repeated in the application using DP
3 Answers DST Global Solutions,
what are inputs for automation?
what is delay in QTP?
How to Import the data from MS-Access in QTP?
In Login two edit box which object class property value is same, How to enter into 2nd edit box in qtp by vbscript.
how do u retrieve data from a database ? i.e. i want to retrieve 2nd record only from a database ? write code for this. by using ADODB connecton, RSOBJ and using a FOR loop we can retrieve all the records( ex: if we give query as select * from emp). but i want only 2nd record. so how to acheive this.
what is mean by soi in object identification
Hi I am new to QTP. can u please answer to my qus... suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query ... please please
can any one tell me what is process metrics and what is product metrics if possible give me example. Thank You
What is the registration process and examination fees?
What is ‘object spy’ and what is the function of object spy in qtp?
describe some problem that u had with automation testing tool?
WinRunner 
