Gets a value that is one more than the index of the last row on this sheet containing data.
Syntax
Visual Basic (Declaration) | |
---|
Public ReadOnly Property NonEmptyRowCount As Integer |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim value As Integer
value = instance.NonEmptyRowCount |
C# | |
---|
public int NonEmptyRowCount {get;} |
Property Value
Integer number of rows that have data
Remarks
Example
This example illustrates the use of this member by returning a value that is one more than the index of the last column and row containing data.
C# | Copy Code |
---|
Random r = new Random();
int countc, countr;
int i, j;
for (i = 0; i<=50; i++)
{
for (j = 0; j<=3; j++)
fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString());
}
countc = fpSpread1.ActiveSheet.NonEmptyColumnCount;
countr = fpSpread1.ActiveSheet.NonEmptyRowCount;
label1.Text = "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 | Copy Code |
---|
Dim r As New Random()
Dim i, j, x As Integer
Dim countc, countr As Integer
For i = 0 To 50
For j = 0 To 3
FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString())
Next j
Next i
countc = FpSpread1.ActiveSheet.NonEmptyColumnCount
countr = FpSpread1.ActiveSheet.NonEmptyRowCount
Label1.Text = "The number of the first non-empty column is " & countc.ToString() & " and the number of the first non-empty
row is " & countr.ToString() |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also