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 / 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
when we use filter funtiom invb script(QTP)
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
How will you convert a given number to long in vbscript?
Description.Create
How to capture a runtime error in vbscript?
What are keywords in the vbscript language?
Explain the operator precedence in vb script?
i have a problem with this error(this error related edit and
delete button,when i click this button in datagrid..i will
get this error)"Invalid postback or callback argument.
Event validation is enabled using
What is the purpose of drive object of scripting.filesystemobject class in vbscript?
who will create the object?
Is vbscript language a case-sensitive language and what does it mean?
Explain about the functionality of vb script?
How to Import data from a file (file is on the desktop) to the data table
Can someone please tell me what poor design in a relational database (not the layout or style) is and how it can be avoided? PLEASE...im desperate.
How to get the length of the string by making use of the string function?