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 |
Write a user defined function to count the no. of buttons existed in a webpage ? i dont want to use descriptive.create ()
how you update scripts in qtp?
What is the default object synchronization timeout in qtp?
Thanks Rag... One more question, How we test the dynamic images which frequently changed?Using the bitmap checkpoint r any other options available.... Can u give the steps pls... Thanks
What is Cross browser testing? Does UFT support it?
i don't have any experience in qtp? Can u please tell me What work i have to do?
how do you invoke the application through QTP?
how we can take data in the username field text box into variable in web application explain with example and give all functions to get data into variables
in Qtp,how to display user name and pwd (script)in data table(global sheet).
Hi All, I want to know how can we schedule QTP scripts. Am using 9.5 version and in our office they want to schedule individual scripts of QTP so that it can run unattended during night time, Please help me how to do that. 2. what is the use of silent test run in qtp can I schedule the scripts in Silent runner, Please explain. 3.I retrieved data from the database using output value -> Database output value. the result of the query for eg is 5 rows, iam able to output the first row by selecting the cols and adding it to output, but am not able to do it for the rest of the rows. please tell me how to do it. Sorry for posting so many qns, am not able to find answ to any of the above in any websites, hoping that someone would really help me with these here, please help me. awaiting for ur immediate revert. Priya
Whether it is possible to test the adobe's controls like zoom, resize, save etc using QTP...If yes, how u can do the same?
What are metrics and matrix?