Spread for ASP.NET 8.0 Product Documentation
NextNonEmptyRow Method (BaseSheetStyleModel)
Example 


Row index after which to start looking (-1 to start at row 0)
Gets the index of the next non-empty row after the specified row index.
Syntax
'Declaration
 
Public Overridable Function NextNonEmptyRow( _
   ByVal row As Integer _
) As Integer
'Usage
 
Dim instance As BaseSheetStyleModel
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 looking (-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
Example
This example returns the index of the next non-empty row after the specified row index.
FarPoint.Web.Spread.Model.BaseSheetStyleModel styleModel;  
FarPoint.Web.Spread.StyleInfo sInfo = new FarPoint.Web.Spread.StyleInfo();  
int i;  
sInfo.BackColor = Color.Red;  
styleModel.SetDirectInfo(0, 0, sInfo);  
styleModel = (FarPoint.Web.Spread.Model.BaseSheetStyleModel)FpSpread1.ActiveSheetView.StyleModel;  
i = styleModel.NextNonEmptyRow(0); 
Response.Write("The next non-empty row is " + i.ToString()); 
Dim styleModel As FarPoint.Web.Spread.Model.BaseSheetStyleModel
Dim sInfo As New FarPoint.Web.Spread.StyleInfo
Dim i As Integer
sInfo.BackColor = Color.Red
styleModel = FpSpread1.ActiveSheetView.StyleModel
styleModel.SetDirectInfo(0, 0, sInfo)
i = styleModel.NextNonEmptyRow(0)
Response.Write("The next non-empty row 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

BaseSheetStyleModel Class
BaseSheetStyleModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.