PreviousNonEmptyColumnInRow Method (Worksheet)

In This Topic

Find the previous non-empty data column in a row

Syntax

Visual Basic
C#

'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

Reference

Worksheet Class
Worksheet Members