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

Namespace:  C1.Silverlight.Excel
Assembly:  C1.Silverlight.Excel.5 (in C1.Silverlight.Excel.5.dll)

Syntax

C#
public class XLColumnCollection : IEnumerable
Visual Basic
Public Class XLColumnCollection _
	Implements IEnumerable

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.

Examples

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:
Copy CodeC#
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.Silverlight.Excel..::..XLColumnCollection

See Also