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

What is difference between vbscript and vba?

612


Write a Program to add 2 numbers without using operators (+,-) and without using third variable. Note: Use VBScript only Hint: You can use other operators like '/' & '*'(Division & Multiplication)

3193


Explain about scrrun.dll?

536


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

3036


What is vbscript language used for and which earlier language is it modeled upon?

536






Anyone have qtp11.0 crack?

2387


Which command is used for writing text on a page?

578


How to Convert Hex color code to color name in VB Script?

3934


What are class variables?

619


What are class events?

583


How are values assigned to string type and numeric type variables?

540


Mention what are the rules to name variable in vbscript?

540


Explain a few date functions in vbscript

558


Explain the tristate constants in vbscript?

561


Mention what is the use of option explicit in vbscript?

551