5.20231.904
wijmo.xlsx Class WorkbookStyle Wijmo API Class

WorkbookStyle Class

Represents the Workbook Object Model style definition used to style Excel cells, columns and rows.

Heirarchy

Constructors

constructor

Properties

basedOn

basedOn: WorkbookStyle

Defines the base style that this style inherits.

This property is applicable for the export operations only. The style gets all the properties defined in the base style, and can override or augment them by setting its own properties.

borders

Gets or sets the border setting.

fill

Gets or sets the background setting.

font

Gets or sets the font of style.

format

format: string

Cell value format, defined using Excel format syntax.

The description of Excel format syntax can be found here.

You may use the toXlsxNumberFormat and toXlsxDateFormat static functions of the Workbook class to convert from .Net (Globalize) format to Excel format.

hAlign

hAlign: HAlign

Gets or sets the horizontal alignment of text.

indent

indent: number

Gets or sets the indent setting of style.

vAlign

vAlign: VAlign

Gets or sets the vertical alignment of text.

wordWrap

wordWrap: boolean

Gets or sets the word wrap setting of row.