ColumnCollection
ColumnCollection class
Collection of the Column objects that represent the individual column(setting)s in a worksheet. The Column object only represents the settings such as column width, styles, .etc. for the whole column, has nothing to do with the fact that there are non-empty cells(data) or not in corresponding column. And the “Count” of this collection only represents the count Column objects that have been instantiated in this collection, has nothing to do with the fact that there are non-empty cells(data) or not in the worksheet.
Properties
| Name | Type | Description |
|---|---|---|
| Count | Number | |
| Item (int) | Column | Gets a Column object by column index. The Column object of given column index will be instantiated if it does not exist |
Methods
| Name | Description |
|---|---|
| getByIndex | Gets the column object by the index. |
NOTE: This member is now obsolete. Instead, please use Columns.GetColumnByIndex() | | getColumnByIndex | Gets the Column object by the position in the list. | | clear | | | removeAt | | | iterator | | | get | Reserved for internal use. | | contains | Reserved for internal use. | | add | Reserved for internal use. | | indexOf | Reserved for internal use. |
ColumnCollection.Count property
Type: Number
ColumnCollection.Item (int) property
Gets a Column object by column index. The Column object of given column index will be instantiated if it does not exist before.
Type: Column
getByIndex(index)
Gets the column object by the index.
NOTE: This member is now obsolete. Instead, please use Columns.GetColumnByIndex() method. This property will be removed 12 months later since June 2010. Aspose apologizes for any inconvenience you may have experienced.
| Parameter | Type | Description |
|---|---|---|
| index | Number |
Returns: Returns the column object.
getColumnByIndex(index)
Gets the Column object by the position in the list.
| Parameter | Type | Description |
|---|---|---|
| index | Number | The position in the list. |
Returns: Returns the column object.
clear()
removeAt(index)
iterator()
get(index)
Reserved for internal use.
contains(value)
Reserved for internal use.
add(value)
Reserved for internal use.
indexOf(value)
Reserved for internal use.