A collection of cell styles.
Methods
CellStyleadd ([withProperties:
Object])
Creates a new CellStyle.
| Parameter | Type | Description |
|---|---|---|
| withProperties | Object | Initial values for properties of the new CellStyle (Optional) |
CellStyleanyItem ()
Returns any CellStyle in the collection.
number count ()
Displays the number of elements in the CellStyle.
Array of CellStyleeveryItem ()
Returns every CellStyle in the collection.
CellStylefirstItem ()
Returns the first CellStyle in the collection.
CellStyleitem (index:
any)
Returns the CellStyle with the specified index or name.
| Parameter | Type | Description |
|---|---|---|
| index | Long Integer String |
The index or name. Can accept: Long Integer or String. |
CellStyleitemByID (id:
number)
Returns the CellStyle with the specified ID.
| Parameter | Type | Description |
|---|---|---|
| id | number | The ID. |
CellStyleitemByName (name:
string)
Returns the CellStyle with the specified name.
| Parameter | Type | Description |
|---|---|---|
| name | string | The name. |
Array of CellStyleitemByRange (from:
any, to:
any)
Returns the CellStyles within the specified range.
| Parameter | Type | Description |
|---|---|---|
| from | CellStyle Long Integer String |
The CellStyle, index, or name at the beginning of the range. Can accept: CellStyle, Long Integer or String. |
| to | CellStyle Long Integer String |
The CellStyle, index, or name at the end of the range. Can accept: CellStyle, Long Integer or String. |
CellStylelastItem ()
Returns the last CellStyle in the collection.
CellStylemiddleItem ()
Returns the middle CellStyle in the collection.
CellStylenextItem (obj:
CellStyle)
Returns the CellStyle whose index follows the specified CellStyle in the collection.
| Parameter | Type | Description |
|---|---|---|
| obj | CellStyle | The CellStyle whose index comes before the desired CellStyle. |
CellStylepreviousItem (obj:
CellStyle)
Returns the CellStyle with the index previous to the specified index.
| Parameter | Type | Description |
|---|---|---|
| obj | CellStyle | The index of the CellStyle that follows the desired CellStyle. |
string toSource ()
Generates a string which, if executed, will return the CellStyle.
Element of:
Application.cellStyles
CellStyleGroup.cellStyles
Document.cellStyles