Spread for ASP.NET 8.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 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.
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());
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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.