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

Count the number of radio buttons and randomly select one.

1 Answers   Deloitte,


describe some problems that u had with automating testing tool?

0 Answers  


QTP 1.What type of bugs u commonly find in u r project? 2.what is agile testing explain with example? 3.application is given req n functionality r missing then how can u start testing? 4.what r the types of defect tracking tools? 5.what is functionality testing? 6.what is change req how u use it? 7.diff bet gul n functional testing? 8.test cases for IE 6.0? 9.where do u store test cases? 10.what r design objects in qtp? 11.what r 5 types of objects in qtp? 12.how to change .mtr to .tsr n vice versa? 13.in which situations qtp will not recoznize objects? 14.how to call .vbs fuctions, library files in qtp? 15.if 10 windows r ope write command to close all windows in qtp? 16from what stage u start automation in u r project? 17.what is VSS? it is usedin automationr manual? 18.size of object repository? 19.how to conduct GUI testing n performance testing on MS-Word? what r performance TEST CASES? 20. use of virtual objects explain? 21.how to connect buzilla with qtp? 22. what is API ? 23.how to merge 2 object repositories in qtp? 24.what is recovery scenario manager? 25. diff bet link n hyper link? 26.diff bet test case n test case scenario? 27.what is relational testing? 28.where do we write test cases? 29.what is base line in testing? 30.what r key process areas(KPA) in u r company? 31.what is hot fix? 32.what is sql injection? 33.what is valnerability? 34.what is TOM in qtp? 35.can we do qtp testing with out creating objects in object repository? can we completely write code in expert view only? 36.where we cant do automation testig? give example using OR is a advantage r a disadvantage?

6 Answers   IBM,


How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.

0 Answers  


Diff b/n image n bitmap checkpoints?

2 Answers   iGate,






How to data driven test for Win objects in QTP ?

0 Answers  


Anybody explain me, the concept of checkpoint declaration in the QTP mainly for the Objects, Pages, Text and Tables ?

1 Answers  


Can any body explain me how to prepare QTP frame work with an example?? alexander.gdk@gmail.com

1 Answers  


How many scripts do you write per day. What is the average number of scripts you have written in your recent project

1 Answers   CenturyLink, Optum, Value Labs,


How to capture all the data of a webtable, weblist and combolist using QTP?

0 Answers   ITC Infotech,


Hi all , I have installed the QTP 11.0 Whenever I am opening QTP that time if any open Internet Explorer I was getting message (Internet Explorer has encountered a problem and needs to close. we are sorry for inconvenience caused) and same way new browser also not opening. If you have any idea please let me know.

2 Answers   ME,


How can we see the analog recording steps in QTP..the Steps are stored in a track file with an extension .dat..how can we open the file..

1 Answers  


Categories