XLColumnCollection Class

Represents a collection of XLColumn objects that represent the individual columns in each XLSheet.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
<System.Reflection.DefaultMemberAttribute("Item")>
Public Class XLColumnCollection

[System.Reflection.DefaultMember("Item")]
public class XLColumnCollection

Remarks

The collection has methods for counting, enumerating, adding, and removing columns from the collection.

The XLColumn objects do not contain any data. If you remove a column from the collection, the data will be lost. If you later re-insert that same column back into the collection, the column will be blank.

Example

Note that you can create columns automatically by using the sheet's indexer. For example, the following code retrieves the cell at coordinates (3,3) and in doing so automatically creates four rows and four columns automatically:

C1XLBook book  = new C1XLBook();
XLSheet  sheet = book.Sheets[0];
XLCell   cell  = sheet[3,3]; // creates 4 rows and 4 columns

Inheritance Hierarchy

System.Object
C1.WPF.Excel.XLColumnCollection

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

XLColumnCollection Members
C1.WPF.Excel Namespace