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 column As Integer, _
   Optional ByVal skipInsideItems As Boolean _
) As Integer

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim skipInsideItems As Boolean
Dim value As Integer
 
value = instance.PreviousNonEmptyColumnInRow(row, column, skipInsideItems)

public int PreviousNonEmptyColumnInRow( 
   int row,
   int column,
   bool skipInsideItems
)

Parameters

row: the start row index
column: the start column index
skipInsideItems: Return the last block index if the found cell is in block with the specified cell.

Return Value

the column index that contains data

Reference

Worksheet Class
Worksheet Members

Product Support Forum | Print this page