NextNonEmptyRow(Int32,SheetArea,StorageType) Method

Gets the index of the next nonempty row of the specified type in the specified area.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function NextNonEmptyRow( _
   ByVal row As System.Integer, _
   ByVal sheetArea As SheetArea, _
   ByVal type As StorageType _
) As System.Integer

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim sheetArea As SheetArea
Dim type As StorageType
Dim value As System.Integer
 
value = instance.NextNonEmptyRow(row, sheetArea, type)

public System.int NextNonEmptyRow( 
   System.int row,
   SheetArea sheetArea,
   StorageType type
)

Parameters

row: The row from which to start searching for the next nonempty row.
sheetArea: The sheet area.
type: Search the next nonempty row based on this type.

Return Value

The next nonempty row index.

Example

This example uses the NextNonEmptyRow method.

gcSpreadSheet1.Sheets[0].Cells[2, 2, 5, 5].Text = "test";

private void button1_Click(object sender, RoutedEventArgs e)
        {
            int j = 0;           

            while (!(j == -1))
            {
                j = gcSpreadSheet1.Sheets[0].NextNonEmptyRow(j, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, GrapeCity.Windows.SpreadSheet.Data.StorageType.Data);
                listBox1.Items.Add(j.ToString());
            }        
        }

VB.NET

GcSpreadSheet1.Sheets(0).Cells(2, 2, 5, 5).Text = "test"

    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        Dim j As Integer
        j = 0

        Do Until j = -1
            j = GcSpreadSheet1.Sheets(0).NextNonEmptyRow(j, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, GrapeCity.Windows.SpreadSheet.Data.StorageType.Data)
            ListBox1.Items.Add(j.ToString())
        Loop
    End Sub

Reference

Worksheet Class
Worksheet Members
Overload List