Gets the number of columns in the model that contain data (bound or unbound).
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overrides ReadOnly Property NonEmptyColumnCount As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As GroupDataModel
Dim value As Integer
value = instance.NonEmptyColumnCount |
| C# | |
|---|
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.
| C# | Copy Code |
|---|
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 | Copy Code |
|---|
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
See Also
