Static $tStatic nextGets the maximum number of items allowed in this collection.
Inserts one or more columns into the collection
InvalidOperationException If the operation is not allowed, e.g. if it would cause data to be shifted off the worksheet.
IndexOutOfRangeException If index is negative.
ArgumentOutOfRangeException If count is less than 1.
the insertion point
The number of columns to insert
Gets the column at the specified index.
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.
The column at the specified index.ArgumentOutOfRangeException 'index' is less than zero.
InvalidOperationException 'index' is greater than or equal to Workbook.maxExcelColumnCount or Workbook.maxExcel2007ColumnCount, depending on the Workbook.currentFormat.
Removes one or more columns from the collection
InvalidOperationException If the operation is not allowed, e.g. if it the range intersects with a protected region.
IndexOutOfRangeException If index is negative.
ArgumentOutOfRangeException If count is less than 1.
the index of the first column to remove point
The number of columns to remove
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic referenceStatic static
A collection of columns in a worksheet.
Columns in this collection are lazily created (they are only created and added to the collection when they are accessed). Therefore, if this collection is enumerated, it only enumerates the columns which were already accessed.
See