We have 10 rows of records in data table, but we have to run
4th, 5th and 6th rows only. How can we handle this scenario
in QTP?
Answers were Sorted based on User's Feedback
Answer / vishakha b
Go to File => Settings. In 'Run' tab, choose the option,
Run from Row. Set '4 to 6' there.
| Is This Answer Correct ? | 26 Yes | 2 No |
Answer / punj
Datatable.setcurrentrow(4)
then use fpr loop, 4 to 6
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / qtp_beginner
DataTable.ImportSheet "C:\Users\Anil\Desktop\Testing_QTP.xls
",1,"Global"
numRow=DataTable.GlobalSheet.GetRowCount
msgbox numRow
For i=4 to 6
DataTable.SetCurrentRow(i)
disp=DataTable.Value ("Test",1)
msgbox disp
Next
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sandeep guttikonda
The abouve provided both answers are correct for this case.
Let me add some more to second answer:
In QTP Data Table Methods we have three methods to work on
rows:
1) SetCurretRow
2) SetNextRow
3) SetPrevRow
Here in our case the best method is SetCurrentRow.
1) SetCurrentRow: We can use this method to take a
specified row s current row in run time datatable. By
default QTP points to 1st Sheet 1st Row.
Syntax: SetCurrentRow(Row Number)
Code:
Datatable.SetCurrentRow(4)
For Current_Row = 4 to 6 step
/* To write the data into the datatable
Datatable.value(Current_Row, Column) = "Sandeep"
OR
/* To get data from the datatable.
Cell_Value = Datatable.value(Current_Row, Column)
Next
Note: Here the variable column is respective column number
on which we want to act.
Please le me know if you need any further info.
Thanks.
Regards,
Sandeep Guttikonda
| Is This Answer Correct ? | 4 Yes | 2 No |
how to capture data from images in QTP and produce them in excel sheet?
DEFECT LIFE CYCLE,WHO PUT THE STATUS AS OPEN
How to test whether the navigation i.e. from one page to another is working r not using QTP for web based application
Write the code for select the 5 values from drop down list. drop down list having the 10 values.
how can i call reusable action in a function could any one explain me?
write a qtp script to verify that the business price is twice the economy price in flight reservation window
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?
How to build scripts that access data from external sources?
What is the standard timing delay for web based application in qtp?
What is the extension of script and object repository files in QTP?
how many scripts r there in QTP? pls any answer this question?