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
- 8826 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
In the Web page we have a table link, if we click on that link all the contents under that link will be sorted (asscending/Descending). Now i want to check in which order the list is ? for that i need to get the data in to some var How can i get that cells data?
How will you get a subset of a array in vbscript?
did any one attended interview in applabs if you had gone through plz tell me the procedure
Explain about .wsf files?
Which in-built functions are used to convert the specified expression in the form of date and string in the vbscript language?
How to make sure that items in a wintree are sorted al?
What is the event handling in vbscript?
Explain about scrrun.dll?
how to write codings in QTP using vb script. please help me. i am new to QTP. it is easy or very much tough. please tell me
what is inner join? what is outer join? what is a constraint? tell me about rdbms? tell me about acid properties?
Hello Guys, If any body looking for "worksoft certify tool training in bangalore", please contact me aimansaud@gmail.com
What are events in the vbscript language?
What is the use of the date function in the vbscript language?
How to identify column in VSFlexgrid? My VSFlexgrid window is identified as 'Active X Control'
Set srchobj=Description.Create() srchobj("type").value="text" srchobj("name").value="q" srchobj("html tag").value="input" browser("micclass:=google").Page("micclass:=google").webedit (srchobj).Set "qtp" what's wrong in my code pls tell me ? the above code working fine and i got my result pass,now i am trying to run the program it shows general run time error why?pls help me i am in learning stage ?
