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 / srinu

setShet = Datatable.Getsheet("Sheet Name")
rowcon=shet.getparameter("colum Name").getrowcount
msgbox rowcon

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention if qtp generates vbscript code as we record actions, can't it possible to directly write using vbscript code when qtp does the same thing too?

528


What is byref and byval parameters in vbscript?

609


what is used of Property........End Property loop ? how to write the script for it?

1693


How to Enter Values on the Command promt using VB script

1534


how to write validation function for date in vb script

2146






what is resorceallocation

1776


Explain about .wsf files?

623


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

1796


What are the special sub-types in vbscript?

554


How will you get the smallest subscript of an array in vbscript?

814


after medical test,when will be the police verification

1719


Can anyone send me a vb script function for verifying the functionality of active links on a web page

1602


What is vbscript?

602


hi Set myobj=Description.Create() myobj("type").value="submit" myobj("name").value="google search" myobj("html tag").value="button" browser("title:=google").page("title:=google").webButton (myobj).Click i was running above code in one weak back it was working fine i got result,again i opened after few days ,again i was trying to run the code it shows run time error in last line of my code ,why ?pls answer my question?

1742


Can we create Crystal Report object in QTP?If yes then what it is and what are its various properties?

3038