WorkbookStyle Class

File: wijmo.xlsx.js
Module: wijmo.xlsx
Implements: IWorkbookStyle

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

Constructor

constructor

Properties

basedOn
borders
fill
font
format
hAlign
indent
vAlign
wordWrap

Constructor

constructor

constructor(): WorkbookStyle

Initializes a new instance of the WorkbookStyle class.

Returns: WorkbookStyle

Properties

basedOn

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.

Type: WorkbookStyle

borders

Gets or sets the border setting.

Type: WorkbookBorder

fill

Gets or sets the background setting.

Type: WorkbookFill

font

Gets or sets the font of style.

Type: WorkbookFont

format

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.

Type: string

hAlign

Gets or sets the horizontal alignment of text.

Type: HAlign

indent

Gets or sets the indent setting of style.

Type: number

vAlign

Gets or sets the vertical alignment of text.

Type: VAlign

wordWrap

Gets or sets the word wrap setting of row.

Type: boolean