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.
class ColumnCollection;
Methods
| Method | Description |
|---|---|
| get(number) | Gets a Column object by column index. The Column object of given column index will be instantiated if it does not exist before. |
| getColumnByIndex(number) | Gets the Column object by the position in the list. |
| getCount() | Gets the number of elements contained in. |
get(number)
Gets a Column object by column index. The Column object of given column index will be instantiated if it does not exist before.
get(columnIndex: number) : Column;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| columnIndex | number |
Returns
getColumnByIndex(number)
Gets the Column object by the position in the list.
getColumnByIndex(index: number) : Column;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number | The position in the list. |
Returns
Returns the column object.
getCount()
Gets the number of elements contained in.
getCount() : number;