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

Why qtp always start action1 and does not start action?

1054


Can we run test with out adding object in object repository? How it is possible?

1040


How to Open FireFox using descriptive programing? If my question is not clear, i will give an Example To Open Internet Explorer, We use Set IE = CreateObject(InternetExplorer.Application) IE.Navigate "www.yahoo.com In the same i need to open yahoo.com in firefox. Can any one tell me what is the server name of firefox to create an object

3045


how can we preform retesting(DATA driven test) using function please gine the code for loginpage

2833


Write a script to verify font style and color of a windows object using descriptive programming

1348


Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?

999


how many maximum number of virtual users we can create?

2096


By using QTP can we record any log files written by the application which is in execution?

1909


How to use the object spy in quicktest professional 8.0 version?

958


How to test results for qtp ?

1203


HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.

2140


How to find the name of the machine where you are running your automation scripts in qtp?

972


What are the types of object repositories? Which one is you using?

1157


i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.

1980


banking domain description for software tester for interview

3886