Spread WPF Documentation
GetNonEmptyColumns Method (Worksheet)
Example 


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

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