ColumnCollection Interface

A collection of all columns in a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

public interface ColumnCollection

VB.NET

Public Interface ColumnCollection

Related API Members

The following members return ColumnCollection objects:

• Worksheet.Columns

Remarks

Worksheet cells are organized into 1,048,576 rows and 16,384 columns. Columns are stored in the ColumnCollection object. Use the Worksheet.Columns property to access this object. The ColumnCollection.Item property enables you to get an individual column by its heading or index in the collection.

To add a new column to the worksheet, use the ColumnCollection.Insert method. To remove a column from the worksheet, use the ColumnCollection.Remove method. For details on how to manage worksheet columns, see the Rows and Columns section of examples.

Example

This example demonstrates how to access columns in a worksheet. Use the Worksheet.Columns property to get a collection of columns contained in a worksheet (the ColumnCollection object). To get an individual column by its index (zero-based) or heading (“A”, “B”, “C”, etc.), use the ColumnCollection.Item property.

C#

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;

// Access a collection of columns.
ColumnCollection columns = workbook.Worksheets[0].Columns;

// Access the first column by its index in the collection of columns.
Column firstColumn_byIndex = columns[0];

// Access the first column by its unique name.
Column firstColumn_byName = columns["A"];

VB.NET

Imports DevExpress.Spreadsheet
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document

' Access a collection of columns.
Dim columns As ColumnCollection = workbook.Worksheets(0).Columns

' Access the first column by its index in the collection of columns.
Dim firstColumn_byIndex As Column = columns(0)

' Access the first column by its unique name.
Dim firstColumn_byName As Column = columns("A")