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
- 8717 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
How strcomp function works?
What is the difference between do until loop and do while loop?
who will create the object?
How are values assigned to the variables in the vbscript language?
how to check whether link is disabled in QTP??
Can anyone send me a vb script function for verifying the functionality of active links on a web page
Explain about filter expression?
Compare java script and vb script?
why variable name should not exceed 255 characters?
How can you create an object in vbscript?
Can u describe what kind of testing are for OTC derivates by banks.
Explain about scrrun.dll in vbscript?
What is the difference between javascript and vbscript?
What is dictionary object in vbscript? Explain?
How to get the length of the string by making use of the string function?
