Gets the index of the next non-empty row after the specified row index.
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 looking (-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 rows contain a value
Example
This example returns the index of the next non-empty row after the specified row index.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.Model.BaseSheetStyleModel styleModel;
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo();
int i;
sInfo.BackColor = Color.Red;
fpSpread1.ActiveSheet.Models.Style.SetDirectInfo(0, 0, sInfo);
styleModel = (FarPoint.Win.Spread.Model.BaseSheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
i = styleModel.NextNonEmptyRow(0)
MessageBox.Show("The next non-empty row is " + i.ToString())
|
| Visual Basic | Copy Code |
|---|
Dim styleModel As FarPoint.Win.Spread.Model.BaseSheetStyleModel
Dim sInfo As New FarPoint.Win.Spread.StyleInfo
Dim i As Integer
sInfo.BackColor = Color.Red
styleModel = FpSpread1.ActiveSheet.Models.Style
FpSpread1.ActiveSheet.Models.Style.SetDirectInfo(0, 0, sInfo)
i = styleModel.NextNonEmptyRow(0)
MessageBox.Show("The next non-empty row is " & i.ToString()) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
