Index Property (Column)

Gets the index of this column, or the starting index for this range of columns.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Index As Integer

'Usage
 
Dim instance As Column
Dim value As Integer
 
value = instance.Index

public int Index {get;}

Property Value

Integer index of this column (or starting column if in a range)

Remarks

Column objects returned by Columns.Default have an index of -1.

This property is available at run time only.

Example

This example illustrates the use of this member by returning the indexes of the Column object.

FarPoint.Win.Spread.Column col;
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
col = fpSpread1.ActiveSheet.Columns[0];
col.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
col.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
col.Width = 120;
fpSpread1.ActiveSheet.Rows[0].Height = 60;

Visual Basic

Dim col As FarPoint.Win.Spread.Column
Dim i, i1 As Integer
col = FpSpread1.ActiveSheet.Columns(0, 2)
i = col.Index
i1 = col.Index2
ListBox1.Items.AddRange(New Object() {i.ToString, i1.ToString})

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

Column Class
Column Members