Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / GroupDataModel Class / NonEmptyRowCount Property

In This Topic
    NonEmptyRowCount Property (GroupDataModel)
    In This Topic
    Gets the number of rows in the model that contain data (bound or unbound).
    Public Overrides ReadOnly Property NonEmptyRowCount As Integer
    Dim instance As GroupDataModel
    Dim value As Integer
    value = instance.NonEmptyRowCount
    public override int NonEmptyRowCount {get;}

    Property Value

    Integer number of the rows that contain data
    This example returns the number of non-empty rows and columns.
    FarPoint.Web.Spread.Model.GroupDataModel gm; 
    if ((FpSpread1.ActiveSheetView.DataModel) is FarPoint.Web.Spread.Model.GroupDataModel) { 
         gm = FpSpread1.ActiveSheetView.DataModel; 
         int r, c;
         r = gm.NonEmptyRowCount
         c = gm.NonEmptyColumnCount
         string msg = r.ToString() + " - " + c.ToString(); 
         Response.Write("alert('" + msg + "')"); 
    Dim gm As FarPoint.Web.Spread.Model.GroupDataModel
    If TypeOf (FpSpread1.ActiveSheetView.DataModel) Is FarPoint.Web.Spread.Model.GroupDataModel Then
        gm = FpSpread1.ActiveSheetView.DataModel
        Dim r, c As Integer
        r = gm.NonEmptyRowCount
        c = gm.NonEmptyColumnCount
        Dim msg As String = r.ToString() & " - " & c.ToString()
        Response.Write("alert('" & msg & "')")
    End If
    See Also