PreviousNonEmptyRowInColumn(Int32,Int32,Boolean) Method

In This Topic

Find the previous non-empty data row in a column

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Function PreviousNonEmptyRowInColumn( _
   ByVal column As Integer, _
   ByVal excludeRow As Integer, _
   Optional ByVal skipInsideItems As Boolean _
) As Integer

'Usage
 
Dim instance As WorksheetBase
Dim column As Integer
Dim excludeRow As Integer
Dim skipInsideItems As Boolean
Dim value As Integer
 
value = instance.PreviousNonEmptyRowInColumn(column, excludeRow, skipInsideItems)

public virtual int PreviousNonEmptyRowInColumn( 
   int column,
   int excludeRow,
   bool skipInsideItems
)

Parameters

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

Return Value

An integer value represents the previous non-empty row in the specified column.

Reference

WorksheetBase Class
WorksheetBase Members