Gets the index of the next row that contains data.

Syntax

Visual Basic (Declaration)
Public Overridable Function NextNonEmptyRow( _ ByVal row As Integer _ ) As Integer

Visual Basic (Usage)	Copy Code
Dim instance As BaseSheetDataModel Dim row As Integer Dim value As Integer value = instance.NextNonEmptyRow(row)

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 row containing a value, or -1 if no rows contain a value

Remarks

This method returns the next row that contains data.

Example

This example returns the next row with data.

C#	Copy Code
FarPoint.Web.Spread.Model.BaseSheetDataModel bdm; int i; bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel; bdm.SetValue(0, 0, "One"); bdm.SetValue(1, 0, "Two"); i = bdm.NextNonEmptyRow(0); Response.Write("The next row with data is " + i.ToString());

Copy Code

FarPoint.Web.Spread.Model.BaseSheetDataModel bdm;
int i;
bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
bdm.SetValue(0, 0, "One");
bdm.SetValue(1, 0, "Two");
i = bdm.NextNonEmptyRow(0);
Response.Write("The next row with data is " + i.ToString());

Visual Basic	Copy Code
Dim bdm As FarPoint.web.Spread.Model.BaseSheetDataModel Dim i As Integer bdm = FpSpread1.ActiveSheetView.DataModel bdm.SetValue(0, 0, "One") bdm.SetValue(1, 0, "Two") i = bdm.NextNonEmptyRow(0) Response.Write("The next row with data is " & i.ToString())

Visual Basic

Copy Code

Dim bdm As FarPoint.web.Spread.Model.BaseSheetDataModel
Dim i As Integer
bdm = FpSpread1.ActiveSheetView.DataModel
bdm.SetValue(0, 0, "One")
bdm.SetValue(1, 0, "Two")
i = bdm.NextNonEmptyRow(0)
Response.Write("The next row with data is " & i.ToString())

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family