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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

Column Class
Column Members