Saturday, 22 January 2011

While on run time, i need to get the row count of a particular column .. the row count means the number of filled rows only.. could you help pls


ANSWER



Please check if the below mentioned logic works for you - 
iCol = 'Column Number
iTotalRows = Br.Pg.WebTable.GetROProperty("rows")
iNonBlankRows = 0 

For i=0 to iTotalRows-10
 If Br.Pg.WT.GetCellData(i,iCol) <> "" Then
   iNonBlankRows = iNonBlankRows  + 1
 Else
   Exit For
 End If
Next 

msgbox "Total Non Blank Rows " & iNonBlankRows 

0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers