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
How to test fly out menu in qtp?
Hi, I am using OutputCheckPoint and I am storing the value in the data table. The stored value for column:bedroom:"Bed:4" The another value for column:bathroom:"Bath:2 Full,1 Partial" I need only the no 4 from the first column. I need only the no 2,1 from the second column. I used split array,but it also show array(0) has the value"bed:4" ..... Even though I highlight only 4,It is seleting the full value "bed 4".How can I get only the nos Thank you Uma
What are private functions in QTP? How they can be called from the function library?
What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)
Subj: realtime example of Database check point, Can any one please detail on how the Database check point is utilized/implemented in a real time project. I already know how to make one by creating DSN/ODBC and writing the required query manually and other steps...I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thank you in advance
What are the features of quick test pro(qtp)?
how many maximum number of virtual users we can create?
Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints
can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com
How many types of parameters are available in quicktest professional?
Can we create a qtp test from qc?
in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?
How you can write contexts to text file in qtp?
How to find the length of the string in qtp?
What is the quicktest professional (qtp) testing process?