Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / uday kumar_anem

Here i am sharing a small snippet script, to import the
data from Excel sheet to QTP during runtime and using the
values.

I have an Excel sheet which contains OrderNumber column and
its values. After that i am displaying the order numbers in
excel during runtime.

datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")
datatable.GetSheet(1)
rowCount=datatable.GetRowCount
For i=1 to rowCount
datatable.SetCurrentRow(i)
val=datatable.Value("OrderNumber","Global")
msgbox(val)
Next

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is Client side image is preferred over server side image?

1953


what the difference between shared repository and per action repository?

1117


How can you identify the browser and its information using the qtp script?

1062


how to write xml output check point bu useing descriptive programing .means without useing output check point

2174


how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

1981


what is the difference between the modular framework and datadriven frame work

2527


How can you send user defined messages to test report?

1111


What is an expert view and keyword view?

1174


What is different command used in command Prompt while using QTP?

2290


what is output value in QTP and how it can be used in automation testing

2049


Explain the types of object repository?

1029


Hi friends I need to know about jubula automation tool. Is anybody know in bangalore where jubula tanning class is going on do let me know. Its urgent for me to learn that tool please help.

3409


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

2855


How to use Environment parameterization? Explain with an example.

2022


what are the mandatory properties for a tex boxc (scenario?)

2046