Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / PreviousNonEmptyCell Method
The row index to find.
The start column index. If the cell in this column is not empty, it'll be returned too.


In This Topic
    PreviousNonEmptyCell Method
    In This Topic
    Gets the nearest previous column which contains data in the specified row.
    Syntax
    'Declaration
     
    
    Public Function PreviousNonEmptyCell( _
       ByVal row As Integer, _
       ByVal excludeColumn As Integer _
    ) As Integer
    'Usage
     
    
    Dim instance As Worksheet
    Dim row As Integer
    Dim excludeColumn As Integer
    Dim value As Integer
     
    value = instance.PreviousNonEmptyCell(row, excludeColumn)
    public int PreviousNonEmptyCell( 
       int row,
       int excludeColumn
    )

    Parameters

    row
    The row index to find.
    excludeColumn
    The start column index. If the cell in this column is not empty, it'll be returned too.

    Return Value

    The nearest previous column which contains data in the specified row.
    See Also