Class

CellStyles

 A collection of cell styles.

See also CellStyle.

QuickLinks

[], add, anyItem, count, everyItem, firstItem, item, itemByID, itemByName, itemByRange, lastItem, middleItem, nextItem, previousItem, toSource

Properties

PropertyTypeAccessDescription
lengthLong Integer
NothingEnum
readonlyThe number of objects in the collection. Can return: Long Integer or NothingEnum enumerator.

Methods

Instances

CellStyle [] (index: number)
Returns the CellStyle with the specified index.

ParameterTypeDescription
indexnumberThe index.

CellStyle add ([withProperties: Object])
Creates a new CellStyle.

ParameterTypeDescription
withPropertiesObjectInitial values for properties of the new CellStyle (Optional)

CellStyle anyItem ()
Returns any CellStyle in the collection.

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

Array of CellStyle everyItem ()
Returns every CellStyle in the collection.

CellStyle firstItem ()
Returns the first CellStyle in the collection.

CellStyle item (index: varies)
Returns the CellStyle with the specified index or name.

ParameterTypeDescription
indexLong Integer
String
The index or name. Can accept: Long Integer or String.

CellStyle itemByID (id: number)
Returns the CellStyle with the specified ID.

ParameterTypeDescription
idnumberThe ID.

CellStyle itemByName (name: string)
Returns the CellStyle with the specified name.

ParameterTypeDescription
namestringThe name.

Array of CellStyle itemByRange (from: varies, to: varies)
Returns the CellStyles within the specified range.

ParameterTypeDescription
fromCellStyle
Long Integer
String
The CellStyle, index, or name at the beginning of the range. Can accept: CellStyle, Long Integer or String.
toCellStyle
Long Integer
String
The CellStyle, index, or name at the end of the range. Can accept: CellStyle, Long Integer or String.

CellStyle lastItem ()
Returns the last CellStyle in the collection.

CellStyle middleItem ()
Returns the middle CellStyle in the collection.

CellStyle nextItem (obj: CellStyle)
Returns the CellStyle whose index follows the specified CellStyle in the collection.

ParameterTypeDescription
objCellStyleThe CellStyle whose index comes before the desired CellStyle.

CellStyle previousItem (obj: CellStyle)
Returns the CellStyle with the index previous to the specified index.

ParameterTypeDescription
objCellStyleThe 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

Jongware, 28-Apr-2012 v3.0.3iContents :: Index