I am using excel sheet to export data to QTP but it
selects just one row of data from excel sheel how to import
all rows of excel sheet to QTP during runtime

Answer Posted / hatim

Hi,
instead of reinventing the wheel try the QTP import method

like this

DataTable.ImportSheet "C:\name.xls" ,"srcSheetname or index
" ,"type your dist data table sheet name here"

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is qtp supports uni-code?

622


what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

1711


Hello everyone! I am just writing a small test for a windows application. I have a problem with a text output value. The value i am trying to catch is presented in a scrollable textbox. When the text is too long, only a portion of it gets captured. Do you have any experience with this?

2151


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

1411


Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris

1750






Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link

878


What is quick test pro?

598


How are cgi programs, applets, javascripts, ActiveX components, etc. to be maintained, tracked, controlled, and tested?

707


How to recognise the webelement and verifying that webelement is enabled?

1656


Is it possible to split an action? How?

662


I want to write some certification courses, so friends could you guide me? which certification is best and how to write exam and what tutorials need to be studied,what to do first, I am working on automation tool QTP 9.2

1504


What are the major/ important methods, functions in QTP we use realtime testing

2276


Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...

1800


How will you handle java tree in qtp?

637


How to change the priorities of the recovery scenario properties?

601