CellStyleGroups

A collection of cell style groups.

Methods

CellStyleGroupadd ([withProperties:
Object])
Creates a new CellStyleGroup.

Parameter Type Description
withProperties Object Initial values for properties of the new CellStyleGroup (Optional)

CellStyleGroupanyItem ()
Returns any CellStyleGroup in the collection.

number count ()
Displays the number of elements in the CellStyleGroup.

Array of CellStyleGroupeveryItem ()
Returns every CellStyleGroup in the collection.

CellStyleGroupfirstItem ()
Returns the first CellStyleGroup in the collection.

CellStyleGroupitem (index:
any)
Returns the CellStyleGroup with the specified index or name.

Parameter Type Description
index Long Integer
String
The index or name. Can accept: Long Integer or String.

CellStyleGroupitemByID (id:
number)
Returns the CellStyleGroup with the specified ID.

Parameter Type Description
id number The ID.

CellStyleGroupitemByName (name:
string)
Returns the CellStyleGroup with the specified name.

Parameter Type Description
name string The name.

Array of CellStyleGroupitemByRange (from:
any, to:
any)
Returns the CellStyleGroups within the specified range.

Parameter Type Description
from CellStyleGroup
Long Integer
String
The CellStyleGroup, index, or name at the beginning of the range. Can accept: CellStyleGroup, Long Integer or String.
to CellStyleGroup
Long Integer
String
The CellStyleGroup, index, or name at the end of the range. Can accept: CellStyleGroup, Long Integer or String.

CellStyleGrouplastItem ()
Returns the last CellStyleGroup in the collection.

CellStyleGroupmiddleItem ()
Returns the middle CellStyleGroup in the collection.

CellStyleGroupnextItem (obj:
CellStyleGroup)
Returns the CellStyleGroup whose index follows the specified CellStyleGroup in the collection.

Parameter Type Description
obj CellStyleGroup The CellStyleGroup whose index comes before the desired CellStyleGroup.

CellStyleGrouppreviousItem (obj:
CellStyleGroup)
Returns the CellStyleGroup with the index previous to the specified index.

Parameter Type Description
obj CellStyleGroup The index of the CellStyleGroup that follows the desired CellStyleGroup.

string toSource ()
Generates a string which, if executed, will return the CellStyleGroup.

Element of:

Application.cellStyleGroups
CellStyleGroup.cellStyleGroups
Document.cellStyleGroups

Leave a Comment

Previous post:

Next post: