5.20231.904
wijmo.xlsx Class WorkbookTableBandedStyle Wijmo API Class

WorkbookTableBandedStyle Class

Represents the WorkbookTableBandedStyle Object Model background setting definition.

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

Table borders 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.

size

size: number

Number of rows or columns in a single band of striping.

vAlign

vAlign: VAlign

Gets or sets the vertical alignment of text.

wordWrap

wordWrap: boolean

Gets or sets the word wrap setting of row.