ColumnCollection.Item[String] Property
Provides access to an individual column in the collection by its heading.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v22.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Parameters
Name | Type | Description |
---|---|---|
columnHeading | String | A string that specifies the heading of the column to be obtained in the A1 reference style (the letter or combination of letters, for example, “A”, “B”, “C”,…,”XFD”). |
Property Value
Type | Description |
---|---|
Column | A Column object that is a column with the specified heading. |
Remarks
The Item property requires the column heading in the A1 reference style, regardless of which cell reference style is used in the workbook (DocumentSettings.R1C1ReferenceStyle). If you need to get a cell range by its R1C1 reference, use the IRangeProvider.Parse method.
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.
using DevExpress.Spreadsheet;
// ...
Workbook workbook = new Workbook();
// 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"];