How to export data in excelsheet to qtp without using
datatable.
- 4 Answers
- 11878 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
Set objInputDataxlsFile=createobject("Excel.Application")
objInputDataxlsFile.workbooks.open <File_name_Path>,true,true
Set
currentworksheet=objInputDataxlsFile.Activeworkbook.Worksheets(1)
UserID = currentworksheet.cells(1,3).value
Password1=currentworksheet.cells(2,3).value
Status = fnLogin 'Call to login function
currentworksheet.cells(4,3).value= Status
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / madhavi
We can create an excel object i qtp and then export or
import data.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / tvs ramakrishna chowdary
sorry ur queston is not proper again post question properly
then i can give answer
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / tvsrkc
we can import data from excel sheet but not export syntax
as follows
datatable.import("d:\sampls.xls")
we can export data from qtp to excel file by using
following syntax
datatable.export("path")
in both situations export/import runtime datatable takes
place
| Is This Answer Correct ? | 1 Yes | 5 No |
how to test Web application using QTP software
Explain the features and benefits of quick test pro(qtp)?
is qtp 9.2 supported for firefox browser3.0?bcoz when i tried to create scripts with the application run on firefox browser 3.0 then qtp 9.2 didn't ct=reate the scripts?
What phases are involved in testing an application in qtp?
Hi any body can tell me the in detaled information about Description.Create() thanks in advance
why use Description programming? what is advantages and disadvantage of this methods?
how to get no.of non empty rows in a excel sheet through vb-script
How many types of actions are there in quicktest professional (qtp)?
Today only i joined in this site. Can u please tell me definition of parameterization. and how i can do the parameterization?
What r the features of QTP9.2,other than QTP8.0 What r the extre features of QTP9.2.
Hello Everybody, please tell me how to use accessibility checkpoint and XML checkpoint by giving any practical example of it.please provide me the steps to perform that and also pls provide the code too. Thanks in advance, Gaytri
Can any one tell me how to write a script for selecting open option in File menu of A word document.here you have to add objects to OR.try like that and give me the ans.i asked this question to so many but no one knows.if any one know the answer plz let me know
WinRunner 
