Spread Windows Forms 9.0 Product Documentation
NextNonEmptyRow Method (BaseSheetDataModel)
Example 


Row index after which to start searching (-1 to start at row 0)
Gets the index of the next row that contains data.
Syntax
'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
Example
This example returns the index of the next row that contains data.
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());    
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.