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 diff between static and dynaic arrys?

1686


Explain different types of segment?

674


Hi Friends, I have an issue like the describe below: I'm using QTP and I'm testing on SharePoint. As you knoe, SharePoint has a customize function for user, so that, If I add an object Web Table at the first time, that object was recognized by "index" and "html tag", after that, if someone change the display of web part, the "Index" of my object was changed as well and QTP unable to select that Web Table. Can you guide me how to identify or anyway to keep that Web Table object as unique object? Thanks a lot.

2648


who will create the object?

1570


What is loose binding? Why is it not a good practice to use it?

735






What is the use of the date function in the vbscript language?

668


after medical test,when will be the police verification

1805


How will you get the last occurrence of one string within another string using vbscript?

805


What are the 2 ways to pass a value to the function?

597


How to open a file. What is the perpose of true and false mode there?

704


How can you destroy an object in vbscript?

751


Explain the adodb.stream class?

642


How strcomp function works?

729


How will you release the memory acquired by an array variable in vbscript?

843


Mention the rules for using option explicit statement?

572