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

DataTable.Addsheet("Destination")
DataTable.ImportSheet "c:\path.xls","source","destination"
row=datatable.getsheet("Destination).getrowcount
for i=1 to row
datatable.SetCurrentRow(i)
val=datatable.Value("path","Global")
msgbox(val)
Next

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I need Major Help with a Script I recorded in QTP 9.5. I am recording scripts for a Web-based application(s) I have all the URLs for each application in Excel spreadhsheet so that QTP can pull that particular application from the spreadsheet and run it. The problem is QTP isn't recognizing one particular URL so when I hit run in QTP to run this script it opens the internet Explorer but isn't open the URL I have in the Excel spreadsheet. I've retyped the URL and still QTP won't open this Particular one for some reason. The site its self is working fine but for whatever reason QTP won't open it. How do I resolve this? I have a deadline of next Friday the 7th to complete this task so please help me in any way you can. Thanks in advance

2161


Suppose I want fail that check point? How can you do that?

1098


Can the user toggle between using Local OR and shared OR for the same action?

967


Tell me about your project? please help me how to tell about insurance project

1988


give me an example where u used good judgement and logic in solving a problem

3854


How to find the difference between 2 dates in qtp?

1039


Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

2086


Explain the difference between call to action and copy action?

980


Hi All, I have QTP installed on my machine but the application under test is on remote machine. I need to automate the scenarios which consist of automatically enter the remote machine through IP address ,record the application in remote machine and run it also when played. Can some one tell how to record the application in remote machine.

2040


Why qtp the best testing tool?

1009


How to find the length of the string in qtp?

1032


I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?

1035


What is the synchronization point in qtp?

1000


What is the parameterization?

1028


Explain about the test fusion report of quicktest professional?

938