ComponentOne ASP.NET MVC Controls
IWorkbookStyle Interface
File
wijmo.xlsx.js
Module
wijmo.xlsx

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

Properties

Properties

basedOn

Defines the base style that this style inherits.

This property is applicable for 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
IWorkbookStyle

borders

Cell outline setting.

Type
IWorkbookBorder

fill

Cells background.

Type
IWorkbookFill

font

Gets or sets the font properties.

Type
IWorkbookFont

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 a text.

Type
HAlign

indent

Text indent. It is an integer value, where an increment of 1 represents 3 spaces.

Type
number

vAlign

Gets or sets the vertical alignment of a text.

Type
VAlign

wordWrap

Word wrap setting.

Type
boolean