GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > NextNonEmptyRow Method : NextNonEmptyRow(Int32,StorageType) Method |
'Declaration Public Overloads Function NextNonEmptyRow( _ ByVal row As System.Integer, _ ByVal type As StorageType _ ) As System.Integer
'Usage Dim instance As Worksheet Dim row As System.Integer Dim type As StorageType Dim value As System.Integer value = instance.NextNonEmptyRow(row, type)
public System.int NextNonEmptyRow( System.int row, StorageType type )
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.StorageType.Data); listBox1.Items.Add(j.ToString()); } }
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.StorageType.Data) ListBox1.Items.Add(j.ToString()) Loop End Sub
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6