A collection of workbook styles, or complex formats which can be easily applied to cells in Microsoft Excel.
Constructors
Section titled "Constructors"WorkbookStyleCollection
new WorkbookStyleCollection(a: Workbook): WorkbookStyleCollectionReturns WorkbookStyleCollection
Properties
Section titled "Properties"$t: TypeAccessors
Section titled "Accessors"count
Section titled "count"Gets the number of styles in the collection. The number of styles in the collection.
get count(): numberReturns number
normalStyle
Section titled "normalStyle"Methods
Section titled "Methods"_u(): IEnumerable$1<WorkbookBuiltInStyle>Returns IEnumerable$1<WorkbookBuiltInStyle>
addUserDefinedStyle
Section titled "addUserDefinedStyle"Adds new user defined style to the workbook.
addUserDefinedStyle(styleFormat: IWorksheetCellFormat, name: string): WorkbookStyleParameters
- styleFormat:
IWorksheetCellFormatA cell format of the style.
- name:
stringThe name which will identify the style in Microsoft Excel.
Returns WorkbookStyle
clear
Section titled "clear"Clears all styles, other than the Normal style, from the collection.
clear(): voidReturns void
contains
Section titled "contains"Determines whether a style is in the collection.
contains(style: WorkbookStyle): booleanParameters
- style:
WorkbookStyleThe style to locate in the collection.
Returns boolean
Gets the style at the specified index. The style at the specified index.
item(index: number): WorkbookStyleParameters
- index:
numberThe zero-based index of the style to get.
Returns WorkbookStyle
remove
Section titled "remove"Removes the specified style from the collection.
remove(style: WorkbookStyle): booleanParameters
- style:
WorkbookStyleThe style to remove from the collection.
Returns boolean
removeAt
Section titled "removeAt"Removes the style at the specified index from the collection.
removeAt(index: number): voidParameters
- index:
numberThe zero-based index of the style in the collection.
Returns void
reset
Section titled "reset"Resets the collection to its original state by clearing all styles and adding in preset built in styles.
reset(): voidReturns void
staticInit
Section titled "staticInit"staticInit(): void