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
- 8027 Views
- Logica CMG, McGraw Hill, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / satya
Here is a piece of code where we are importing the exl
sheet DS and getting row count then using them in For Loop.
datatable.AddSheet ("DS")
Datatable.ImportSheet "C:\satya.xls","DS","DS"
RowCount = Datatable.GetSheet("DS").GetRowCount
For RowCount = 0 to RowCount -1
Datatable.GetSheet("DS").SetCurrentrow(RowCount +1)
val = Datatable.RawValue("username","DS")
msgbox val
Next
hope it clear u...!
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / srinu
setShet = Datatable.Getsheet("Sheet Name")
rowcon=shet.getparameter("colum Name").getrowcount
msgbox rowcon
| Is This Answer Correct ? | 3 Yes | 5 No |
What is the event handling in vbscript?
To get data from table which method will be used in QTP
How to scroll down a page while recording in qtp. suggest me any method apart from low level recording.
write a vb script to calculate factorial of a number?
How to get 120 using 5 zeroes, you can use any operator(+, *, /...) in qtp.
What are the naming conventions while declaring a variable in the vbscript language?
Explain about tristate constants?
how to increase the values in text box in a given text box increament by two values by clicking on button
What is the extension of the vbscript file?
how to retrieve native property value in runtime?
write a vb script to display the size of the folder,date created and name of the folder
a function that takes an integer array as an argument and returns the largest value in the array. Use the function in a program
ASP 
