IXlCell.ColumnIndex Property

Gets the index of the column that contains the current cell.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

int ColumnIndex { get; }

VB.NET

ReadOnly Property ColumnIndex As Integer

Property Value

Type	Description
Int32	A zero-based integer value that specifies the index of the column containing the current cell.

Remarks

Use the ColumnIndex and IXlCell.RowIndex properties to obtain indexes of the column and row at the intersection of which the current cell is located.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ColumnIndex property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples/CS/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.cs#L239

using(IXlCell cell = row.CreateCell()) {
    cell.Value = cell.ColumnIndex * cell.RowIndex + cell.RowIndex + 1;
}

VB.NET

excel-export-api-examples/VB/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.vb#L238

Using cell As IXlCell = row.CreateCell()
    cell.Value = cell.ColumnIndex * cell.RowIndex + cell.RowIndex + 1
End Using