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 |
i this is balaji from chennai i have 4 yrs exp in testing and my qualification is bsc computers i completed in correspondace in which companiies accept the correspondace plz let me know
Will there be any standards or requirements for page appearance and/or graphics throughout a site or parts of a site?
How many number of actions possible in qtp?
we have 5 default properties we want add more Default property in Object Repository how to add the property
Per-Action Vs Shared repository?
write the regular expression for date format of mm/dd/yy?
10 Answers CTS, HCL,
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?
I have test cases in excel sheet but i am using quality center.How can i copy the testcases from excel sheet to quality center?explain this process.
can we do load testing , by using QTP......?
What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?
what are the cases in which we use XML and accessibility check points.
hi this is srinivasa(from blr) i complited my B.tech(e.c.e) in 2007 im searching job in s/w testing but idont have freshers resume for s/w testing please send some s/w testing resume for me(fresfers resumes only) advns thnks you