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 |
How to export data present in Datatable to an ".xls" file?
what is difference between analog and low level recording
When you open QTP, how many sheets you can see?
What is the basic concept of quicktest professional?
In smart identification, explain about 1. Base filter properties 2. optional filter properties with examples?
what is main difference between QTP 8.2 AND QTP 9.0/9.2 HOME PAGE?i mean what are extra thing in QTP 9.0 than in QTP 8.2?
How to call a function in QTP?Is there any method ? Thanks , PRASANNA
What are default add-ins in qtp?
I have a tool bar where 5 different buttons are placed, but these buttons are not traceable hence i have created a virtual object on save button of this toolbar. Now pls tell me how to use this virtual object while write script.
hi Sudhananda reddy, in my resume, i written as , I Am working as a Test Engineer for xyz company. IS IT RIGHT OR WRONG? WHAT IS THE ACTUAL meaning of "IN XYZ COMPANY", "FOR XYZ COMPANY", "WITH XYZ COMPANY".
what are the different u notice in betweem QTP version 8.2 and 9.2 and what is new in QTP9.2
Hi I am working with QTP.If I want to write a certification exams,Which one is the best one suggest me friends!!