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

    Reference

    Worksheet Class
    Worksheet Members