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
- 8967 Views
- Logica CMG, McGraw Hill, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why is it recommended to close the database connection every time after the work is completed?
PLz send me the VB scripts which is having more examples my email id : hareen_11@yahoo.com
i wrote vbscripit code in notepad i got error i am in learning stage if u ps tell me what wrong in my code my error is "object required descriptive at line one run time error"and my code is "set usernameobj=Descriptive.Create() usernameobj( "name").value="Username" set passwordobj=Descriptive.Create() passwordobj("name").value="password" set signinobj=Descriptive.Create() signinobj("name").value="sigin" browser("gmail").page("gmail").WebEdit("usernameobj").set ("enter username") Browser("gmail").Page("gmail").WebEdit("passwordobj").Set secure.Crypt.Encrypt("enter password") browser("gmail").page("gmail").WebButton("siginobj").click
Which in-built function related to an array joins substrings into one string in the vbscript language?
after medical test,when will be the police verification
Explain about scrrun.dll in vbscript?
Compare java script and vb script?
Can u describe what kind of testing are for OTC derivates by banks.
Which operator can be used to do an xor operation in vbscript?
What are lbound and ubound in the vbscript language?
How will you get a string with the specified character the specified number of times in vbscript?
What is vbscript?
How to Enter Values on the Command promt using VB script
Is vbscript a case-sensitive or case-insensitive?
How can you create an object in vbscript?
