Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / PreviousNonEmptyColumnInRow Method
the start row index
the start column index
Return the last block index if the found cell is in block with the specified cell.
true if spilled value is count as empty.


In This Topic
    PreviousNonEmptyColumnInRow Method (Worksheet)
    In This Topic
    Find the previous non-empty data column in a row
    Syntax
    'Declaration
     
    
    Public Function PreviousNonEmptyColumnInRow( _
       ByVal row As Integer, _
       ByVal excludeColumn As Integer, _
       Optional ByVal skipInsideItems As Boolean, _
       Optional ByVal unspilledValue As Boolean _
    ) As Integer
    'Usage
     
    
    Dim instance As Worksheet
    Dim row As Integer
    Dim excludeColumn As Integer
    Dim skipInsideItems As Boolean
    Dim unspilledValue As Boolean
    Dim value As Integer
     
    value = instance.PreviousNonEmptyColumnInRow(row, excludeColumn, skipInsideItems, unspilledValue)
    public int PreviousNonEmptyColumnInRow( 
       int row,
       int excludeColumn,
       bool skipInsideItems,
       bool unspilledValue
    )

    Parameters

    row
    the start row index
    excludeColumn
    the start column index
    skipInsideItems
    Return the last block index if the found cell is in block with the specified cell.
    unspilledValue
    true if spilled value is count as empty.

    Return Value

    the column index that contains data
    See Also