Item Property (WorksheetColumnCollection)

Gets the column at the specified index.

Syntax

Visual Basic

'Declaration
 
Public ReadOnly Default Property Item( _
   ByVal index As Integer _
) As WorksheetColumn

C#

public WorksheetColumn this[ 
   int index
]; {get;}

Parameters

index

The zero-based index of the column to get.

Property Value

The column at the specified index.

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	index is less than zero.
System.InvalidOperationException	index is greater than or equal to Workbook.MaxExcelColumnCount or Workbook.MaxExcel2007ColumnCount, depending on the CurrentFormat.

Remarks

Note: Iterating the collection will not create all columns. It will only iterate the columns which have already been used. To create and iterate all columns in the worksheet use a For loop, iterating from 0 to one less than the maximum column count, and pass in each index to the collection's indexer.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2