NonEmptyRowCount Property (INonEmptyCells)

Visual Basic
C#

'Declaration
 
ReadOnly Property NonEmptyRowCount As Integer

'Usage
 
Dim instance As INonEmptyCells
Dim value As Integer
 
value = instance.NonEmptyRowCount

int NonEmptyRowCount {get;}

Property Value

Integer number of rows that are not empty

This method gets a value that is one more than the index of the last row in the model that contains data.

C#

FarPoint.Web.Spread.Model.INonEmptyCells nec; 
Random r = new Random(); 
int countc, countr; 
int i, j; 
for (i = 0; i<=1; i++) 
{ 
     for (j = 0; j<=2; j++) 
          FpSpread1.ActiveSheetView.SetValue(i, j, r.Next(1, 200).ToString()); 
} 
nec = (FarPoint.Web.Spread.Model.INonEmptyCells)FpSpread1.ActiveSheetView.DataModel; 
countc = nec.NonEmptyColumnCount; 
countr = nec.NonEmptyRowCount; 
Response.Write("The number of the first non-empty column is " + countc.ToString() + " and the number of the first non-empty
row is " + countr.ToString());

Visual Basic

Dim nec As FarPoint.Web.Spread.Model.INonEmptyCells
Dim r As New Random
Dim i, j As Integer
Dim countc, countr As Integer
For i = 0 To 1
     For j = 0 To 2
          FpSpread1.ActiveSheetView.SetValue(i, j, r.Next(1, 200).ToString())
     Next j
Next i
nec = FpSpread1.ActiveSheetView.DataModel
countc = nec.NonEmptyColumnCount
countr = nec.NonEmptyRowCount
Response.Write("The number of the first non-empty column is " & countc.ToString() & " and the number of the first non-empty
row is " & countr.ToString())

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

INonEmptyCells Interface
INonEmptyCells Members