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?
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
What is the difference between vb debugger and the script debugger?
How do you declare a variable in vbscript?
Illustrate briefly about the different types of statement
What aspects of vbscript make it safe so that a web page using vbscript cannot destroy or corrupt information on a user's computer?
What are the 2 ways to pass a value to the function?
Write a test case using Test if the images,a particular test exists,check if the page links match,page response is within a certain range,parameterization of the test,the test should comprise of actions,the test should use a custom function,the test should use global repository
What are string functions in vbscript?
What purpose does ‘on error resume next’ serves?
Explain about tristate constants in vbscript?
Mention how to create a cookie using vbscript?
What is the extension of the vbscript file?
What is the difference between a dictionary and an array?
What are keywords in the vbscript language?
We have 1 web page with names column. I am giving the Service Providers1,2,3.... @ that time dynamically some no of names are displaying in the webpage and The Pop up windows are opening(No.of Pop Up windows=No.of Names). The names may be diffar for each and every Service Provders (Dynamically) How can we handle the Dynamic values?
How are arrays declared in the vbscript language?