A collection of workbook styles, or complex formats which can be easily applied to cells in Microsoft Excel.

Inheritance

Implements
  • ICollection<WorkbookStyle>
  • IEnumerable<WorkbookStyle>
  • IEnumerable

Gets the number of styles in the collection.

public int Count { get; }

Gets the style at the specified index.

public WorkbookStyle this[int index] { get; }

Gets the style with the specified name.

public WorkbookStyle this[string name] { get; }

Gets the default style for the workbook.

public WorkbookStyle NormalStyle { get; }

AddUserDefinedStyle(IWorksheetCellFormat, string)

Section titled "AddUserDefinedStyle(IWorksheetCellFormat, string)"

Adds new user defined style to the workbook.

public WorkbookStyle AddUserDefinedStyle(IWorksheetCellFormat styleFormat, string name)

Parameters

  • styleFormat: IWorksheetCellFormat
  • name: string

Returns any

Adds new user defined style to the workbook.

public WorkbookStyle AddUserDefinedStyle(string name)

Parameters

  • name: string

Returns any

Clears all styles, other than the Normal style, from the collection.

public void Clear()

Returns any

Determines whether a style is in the collection.

public bool Contains(WorkbookStyle style)

Parameters

  • style: WorkbookStyle

Returns any

Removes the specified style from the collection.

public bool Remove(WorkbookStyle style)

Parameters

  • style: WorkbookStyle

Returns any

Removes the style at the specified index from the collection.

public void RemoveAt(int index)

Parameters

  • index: int

Returns any

Resets the collection to its original state by clearing all styles and adding in preset built in styles.

public void Reset()

Returns any