How to export data in excelsheet to qtp without using
datatable.

Answers were Sorted based on User's Feedback



How to export data in excelsheet to qtp without using datatable...

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

How to export data in excelsheet to qtp without using datatable...

Answer / madhavi

We can create an excel object i qtp and then export or
import data.

Is This Answer Correct ?    4 Yes 2 No

How to export data in excelsheet to qtp without using datatable...

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

How to export data in excelsheet to qtp without using datatable...

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

Post New Answer

More QTP Interview Questions

What are the Features & Benefits of Quick Test Pro (QTP)..?

5 Answers  


Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance

0 Answers  


hi i have one issue while selecting weblist i want show one particalur item in weblist .ex one weblist they are monday to sunday i want show the reporter like thurday in particular weblist can you help me about this thanks balaji

5 Answers  


several browsers opened. write QTP script to close all browsers except gmail.

1 Answers   Thomson Reuters,


what is vmodel?advantages and disadvantages of vmodel?

0 Answers   AZTEC,


What is the Diff between Image check-point and Bit map Check point?

3 Answers   Ordain Solutions,


i don't have any experience in qtp? Can u please tell me What work i have to do?

4 Answers  


can u give one scenario for for PopWindow Exception & write Code for that?

2 Answers   Cap Gemini,


what are the mandatory properties in qtp? what are the library functions in qtp?

3 Answers   Wipro,


want to learn real time automation project(QTP)?

1 Answers  


how to call a funtion in a script? i have saved the login scipt in notepad. with extension .vbs. But when i am calling the function with the keyword CALL <Function Name>. its not working out. can any one give me a clue how to call the external functions. with example.

3 Answers  


for example u can take ebay or plifcart online shoping web application--------- write acode in vbscript in qtp---- search box and write (iphone6)and click on go button then opened diff prise iphones in next page but u can select 30,000 to 90,000 list pls write code? 

2 Answers   FFASVA, Genpact, Wipro,


Categories