Worksheet cells are organized into 1,048,576 rows and 16,384 columns that are stored in the RowCollection and ColumnCollection objects, respectively. To access these objects, use the Worksheet.Rows and Worksheet.Columns properties.
The Column object specifies an individual column in a worksheet and can be accessed by the column index or heading. Use this object's properties and methods to manage worksheet columns. For details, see the Rows and Columns section of examples.
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; // ... IWorkbook workbook = spreadsheetControl1.Document; // Access a collection of columns. ColumnCollection columns = workbook.Worksheets.Columns; // Access the first column by its index in the collection of columns. Column firstColumn_byIndex = columns; // Access the first column by its unique name. Column firstColumn_byName = columns["A"];
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")