NextNonEmptyRow Method (BaseSheetDataModel)

Visual Basic
C#

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

'Usage
 
Dim instance As BaseSheetDataModel
Dim row As Integer
Dim value As Integer
 
value = instance.NextNonEmptyRow(row)

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

This example returns the index of the next row that contains data.

C#

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

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())

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members