Gets the index of the next row that contains data.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overridable Function NextNonEmptyRow( _
ByVal row As Integer _
) As Integer |
| C# | |
|---|
public virtual int NextNonEmptyRow(
int row
) |
Parameters
- row
- Row index after which to start searching (-1 to start at row 0)
Return Value
Integer row index for the next cell in the column containing a value, or -1 if no row contain a value
Example
This example returns the index of the next row that contains data.
| C# |  Copy Code |
|---|
Random r = new Random();
int i, j;
for (i = 1; i <= 50; i++)
{
for (j = 1; j <= 3; j++)
{
fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString());
}
}
FarPoint.Win.Spread.Model.BaseSheetDataModel bsm;
bsm = (FarPoint.Win.Spread.Model.BaseSheetDataModel)fpSpread1.ActiveSheet.Models.Data;
MessageBox.Show(bsm.NextNonEmptyRow(1).ToString());
|
| Visual Basic | Copy Code |
|---|
Dim r As New Random
Dim i, j As Integer
For i = 1 To 50
For j = 1 To 3
FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString())
Next j
Next i
Dim bsm As FarPoint.Win.Spread.Model.BaseSheetDataModel
bsm = FpSpread1.ActiveSheet.Models.Data
MessageBox.Show(bsm.NextNonEmptyRow(1).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
