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

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

    Property Value

    Integer number of the columns 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