How to export data in excelsheet to qtp without using
datatable.
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 |
Where the text version of script file located in file system?
how to retrieve the xml file data through qtp. can anybody send script for this..
is it possible to add sheets to excel at runtime
What is the basic concept of quicktest professional (qtp)?
What are advantages of test automation?
what is compiled module?
What are the Features & Benefits of Quick Test Pro ?
what is the diffrence bw qtp architectute and qtp framework?
Hi ,Can any one pleas explain how to test splash objects using QTP?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation.....
Difference between image checkpoint and bitmap checkpoint