GetNonEmptyColumns Method (Worksheet)

Returns a list of nonempty column indexes.

Syntax

Visual Basic
C#

'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());

VB.NET

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())

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Worksheet Class
Worksheet Members