Gets the number of rows in the model that contain data (bound or unbound).
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overrides ReadOnly Property NonEmptyRowCount As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As GroupDataModel
Dim value As Integer
value = instance.NonEmptyRowCount |
| C# | |
|---|
public override int NonEmptyRowCount {get;} |
Property Value
Integer number of the rows 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
