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 event handling in vbscript?
what is the features of visual basic?
How to find the font in qtp. Scenario:After entering the username and passwd you will be navigate into the "welcome:Username" page.Now I want to extarct font for this message.
What is difference between vbscript and vba?
What are class properties?
Explain sga memory structures?
What's the difference between vbscript and vb.net?
How to make sure that items in a wintree are sorted al?
1) How can we use VB script in testing the application? 2) What all are the things(Software application to be installed in PC) we need to learn VBscript?
1. How to handle object implementation change in DP for Ex: i have login page with username,pasword (editboxes),login,cancel(buttons). Here i written DP code for login page with the help properties. My questions: 1.If properites are changing dynamically i will do (i want code for that) 2.if objects are changed dynamcally i will do (i wnat code for that)
Explain vbscript in detail?
How will you convert a string to upper case string using vbscript?
can anyone tell me the procedure of interview held in applabs
write a function to read the items from combobox of Flight reservation & save in excel (QTP)??
what do you mean .ota mobile format