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
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
Suppose I want fail that check point? How can you do that?
Can the user toggle between using Local OR and shared OR for the same action?
Tell me about your project? please help me how to tell about insurance project
give me an example where u used good judgement and logic in solving a problem
How to find the difference between 2 dates in qtp?
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
Explain the difference between call to action and copy action?
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.
Why qtp the best testing tool?
How to find the length of the string in qtp?
I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?
What is the synchronization point in qtp?
What is the parameterization?
Explain about the test fusion report of quicktest professional?