NextNonEmptyRow Method (SubWorksheet)

In This Topic

Find the next non-empty row data in a column

Syntax

Visual Basic
C#

'Declaration
 
Public Function NextNonEmptyRow( _
   ByVal column As Integer, _
   ByVal column2 As Integer, _
   ByVal excludedRow As Integer, _
   Optional ByVal skipInsideItems As Boolean _
) As Integer

'Usage
 
Dim instance As SubWorksheet
Dim column As Integer
Dim column2 As Integer
Dim excludedRow As Integer
Dim skipInsideItems As Boolean
Dim value As Integer
 
value = instance.NextNonEmptyRow(column, column2, excludedRow, skipInsideItems)

public int NextNonEmptyRow( 
   int column,
   int column2,
   int excludedRow,
   bool skipInsideItems
)

Parameters

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

Return Value

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

Reference

SubWorksheet Class
SubWorksheet Members