NonEmptyColumnCount Property (GroupDataModel)

Gets the number of columns in the model that contain data (bound or unbound).

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides ReadOnly Property NonEmptyColumnCount As Integer

'Usage
 
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

Example

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 + "')"); 
}

Visual Basic

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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GroupDataModel Class
GroupDataModel Members