Spread WPF Documentation
NextNonEmptyRow(Int32) Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > NextNonEmptyRow Method : NextNonEmptyRow(Int32) Method
The row whose next nonempty row is to be returned.
Returns the next nonempty row index for the specified column.
Syntax
'Declaration
 
Public Overloads Function NextNonEmptyRow( _
   ByVal row As System.Integer _
) As System.Integer
'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim value As System.Integer
 
value = instance.NextNonEmptyRow(row)
public System.int NextNonEmptyRow( 
   System.int row
)

Parameters

row
The row whose next nonempty row is to be returned.

Return Value

The next nonempty row index.
Example
This example uses the NextNonEmptyRow method.
gcSpreadSheet1.Sheets[0].Cells[2, 2].Text = "test";

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

            while (!(j == -1))
            {
                j = gcSpreadSheet1.Sheets[0].NextNonEmptyRow(j);
                listBox1.Items.Add(j.ToString());
            }
        }
GcSpreadSheet1.Sheets(0).Cells(2, 2).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)
            ListBox1.Items.Add(j.ToString())
        Loop
End Sub
See Also

Reference

Worksheet Class
Worksheet Members
Overload List