Spread WPF Documentation
GetNonEmptyRows Method (Worksheet)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class : GetNonEmptyRows Method
Returns a list of nonempty row indexes.
Syntax
'Declaration
 
Public Function GetNonEmptyRows() As System.Collections.Generic.List(Of Integer)
'Usage
 
Dim instance As Worksheet
Dim value As System.Collections.Generic.List(Of Integer)
 
value = instance.GetNonEmptyRows()
public System.Collections.Generic.List<int> GetNonEmptyRows()

Return Value

A list of indexes.
Example
This example uses the GetNonEmptyColumns method.
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetNonEmptyColumns().Count.ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetNonEmptyRows().Count.ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetRowAutoText(3).ToString());
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetNonEmptyColumns.Count.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetNonEmptyRows.Count.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetRowAutoText(3).ToString())
See Also

Reference

Worksheet Class
Worksheet Members