Interested to Buy Any Domain ? << Click Here >> for more details...
How to export data in excelsheet to qtp without using
datatable.
- 4 Answers
- 12918 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 |
Please explain how to open with notepad of saved html file by right click option using QTP
What is the extension of script and object repositary files?
HOW to invoke any recorded script in QTP with out using RECORD & PLAYBACK CONCEPT?
This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10
What is meant by Repository?
7 Answers ALFiNE IT Solutions, Four soft,
can any one give me the doccument how to test aproject developed in java language in qtp can here can we use the general vb scripting or we have to use java script here if we have to ese the java script here can any one send me the manual for it means how to write descriptive programming for it thanks in advance
How do u do batch testing in WR & is it possible to do in QTP, if so explain?
Batch testing in howmany ways u perfrom in QTP
How to retrieve the property of an object in QTP?
Can you give me the code to calculate the total number of Links using the child object in the web page..? is there any other way to calculate number of links with out using the Child objects.??
2 Answers DST Global Solutions,
give me the code to save all messages of inbox of gmail into a folder and notepad
I need to know how to Automate a Username and Password for a Web-based product? I'm scripting 3 different types of surveys but each Survey requires a Username and Password which is always the same. I can I do this using QTP?
WinRunner 
