Interested to Buy Any Domain ? << Click Here >> for more details...
When importing an excel file that has several columns each
with different number of rows into QTP's Global datatable,
how can you count the number of rows in a particular column?
- 3 Answers
- 8648 Views
- Logica CMG, McGraw Hill, I also Faced
- E-Mail Answers
Answer Posted / pushkar1206
datatable.ImportSheet "C:UserspushkarDesktop123.xls","Sheet1","Action1"
rw=datatable.GetSheet("Action1").GetRowCount
For i=1 to rw
a=datatable.GetSheet("Action1").GetParameter("_11").ValueByRow(i)
c=len(a)
If c>0 Then
b=b+1
End If
Next
msgbox b
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I have attended Anovatek Software QTP interview. They will give us computer and one web based application with QTP. We have to automate some records (already updated records or new records) using QTP Data driven testing. But we should use for loop? Can any one know how to do data driven testing using For loop?
What are the advantages of vbscript?
when we use filter funtiom invb script(QTP)
Difference between dim,public and private variables in vb script?
Can automation testing find ssame no. of bugs what we can find by manual testing?
Write a code to print numbers from 5 to 0?
How to make professional test report using vbscript code in UFT, which gives us complete analysis of the test.
Write a vbscript procedure that converts feet to inches. Hint: there are 12 inches in a foot?
Which function allows you to instantiate an object given its programmatic identifier or progid?
How will you convert a string to lower case string using vbscript?
Which keyword is used to declare a variable in the vbscript language?
How are values assigned to the variables in the vbscript language?
Mention when to use function procedures and what are its characteristics?
How many types of procedures are available in the vbscript language?
How you can call vbscript functions?
