Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / BaseSheetDataModel Class / NextNonEmptyColumnInRow Method
Row index to search
Column index before the column to start searching (-1 to start at column 0)
Example


In This Topic
    NextNonEmptyColumnInRow Method (BaseSheetDataModel)
    In This Topic
    Gets the index of the next column in a specified row that contains data.
    Syntax
    'Declaration
     
    Public Overridable Function NextNonEmptyColumnInRow( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Integer
    'Usage
     
    Dim instance As BaseSheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Integer
     
    value = instance.NextNonEmptyColumnInRow(row, column)
    public virtual 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 next column 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(0, 1, "Two");
    i = bdm.NextNonEmptyColumnInRow(0, 0);
    Response.Write("The next column 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(0, 1, "Two")
    i = bdm.NextNonEmptyColumnInRow(0, 0)
    Response.Write("The next column with data is " & i.ToString())
    See Also