Gets the index of the next column in a specified row that contains data.

Syntax

Visual Basic (Declaration)
Public Overrides Function NextNonEmptyColumnInRow( _ ByVal row As Integer, _ ByVal column As Integer _ ) As Integer

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim value As Integer value = instance.NextNonEmptyColumnInRow(row, column)

C#
public override int NextNonEmptyColumnInRow( int row, int column )

Parameters

row: Row index to search
column: Column index before the column to start searching (-1 to start at column 0)

Return Value

Integer column index for the next cell in the row containing a value, or -1 if no columns contain a value

Remarks

This method returns the index of the next column in the row that contains data.

Example

This example returns the index of the next column in a specified row that contains data.

C#	Copy Code
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); DataSet ds = new DataSet(); DataTable name; name = ds.Tables.Add("Name"); name.Columns.Add("FirstName", Type.GetType("System.String")); name.Columns.Add("LastName", Type.GetType("System.String")); name.Rows.Add(new object[] {"John", "Doe"}); name.Rows.Add(new object[] {"Sally ", "Jones"}); name.Rows.Add(new object[] {"Terry", "Hernandez"}); dataModel.DataSource = ds; FpSpread1.ActiveSheetView.DataModel = dataModel; dataModel.AddUnboundRows(1, 2); name.Rows.Add(new object[] {"Jane", "Simpson"}); int i; i = dataModel.NextNonEmptyColumnInRow(1, 2); Response.Write(i.ToString());

Copy Code

FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
DataSet ds = new DataSet(); 
DataTable name; 
name = ds.Tables.Add("Name"); 
name.Columns.Add("FirstName", Type.GetType("System.String")); 
name.Columns.Add("LastName", Type.GetType("System.String")); 
name.Rows.Add(new object[] {"John", "Doe"}); 
name.Rows.Add(new object[] {"Sally ", "Jones"}); 
name.Rows.Add(new object[] {"Terry", "Hernandez"}); 
dataModel.DataSource = ds; 
FpSpread1.ActiveSheetView.DataModel = dataModel; 
dataModel.AddUnboundRows(1, 2); 
name.Rows.Add(new object[] {"Jane", "Simpson"}); 
int i; 
i = dataModel.NextNonEmptyColumnInRow(1, 2); 
Response.Write(i.ToString());

Visual Basic	Copy Code
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel Dim ds As New DataSet Dim name As DataTable name = ds.Tables.Add("Name") name.Columns.Add("FirstName", Type.GetType("System.String")) name.Columns.Add("LastName", Type.GetType("System.String")) name.Rows.Add(New Object() {"John", "Doe"}) name.Rows.Add(New Object() {"Sally ", "Jones"}) name.Rows.Add(New Object() {"Terry", "Hernandez"}) dataModel.DataSource = ds FpSpread1.ActiveSheetView.DataModel = dataModel dataModel.AddUnboundRows(1, 2) name.Rows.Add(New Object() {"Jane", "Simpson"}) Dim i As Integer i = dataModel.NextNonEmptyColumnInRow(1, 2) Response.Write(i.ToString())

Visual Basic

Copy Code

Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
Dim ds As New DataSet
Dim name As DataTable
name = ds.Tables.Add("Name")
name.Columns.Add("FirstName", Type.GetType("System.String"))
name.Columns.Add("LastName", Type.GetType("System.String"))
name.Rows.Add(New Object() {"John", "Doe"})
name.Rows.Add(New Object() {"Sally ", "Jones"})
name.Rows.Add(New Object() {"Terry", "Hernandez"})
dataModel.DataSource = ds
FpSpread1.ActiveSheetView.DataModel = dataModel
dataModel.AddUnboundRows(1, 2)
name.Rows.Add(New Object() {"Jane", "Simpson"})
Dim i As Integer
i = dataModel.NextNonEmptyColumnInRow(1, 2)
Response.Write(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