Excel.Interfaces.StyleUpdateData interface

An interface for updating data on the Style object, for use in style.set({ ... }).

Properties

borders

A collection of four border objects that represent the style of the four borders.

fill

The fill of the style.

font

A Font object that represents the font of the style.

formulaHidden

Specifies if the formula will be hidden when the worksheet is protected.

horizontalAlignment

Represents the horizontal alignment for the style. See Excel.HorizontalAlignment for details.

includeAlignment

Specifies if the style includes the auto indent, horizontal alignment, vertical alignment, wrap text, indent level, and text orientation properties.

includeBorder

Specifies if the style includes the color, color index, line style, and weight border properties.

includeFont

Specifies if the style includes the background, bold, color, color index, font style, italic, name, size, strikethrough, subscript, superscript, and underline font properties.

includeNumber

Specifies if the style includes the number format property.

includePatterns

Specifies if the style includes the color, color index, invert if negative, pattern, pattern color, and pattern color index interior properties.

includeProtection

Specifies if the style includes the formula hidden and locked protection properties.

indentLevel

An integer from 0 to 250 that indicates the indent level for the style.

locked

Specifies if the object is locked when the worksheet is protected.

numberFormat

The format code of the number format for the style.

numberFormatLocal

The localized format code of the number format for the style.

readingOrder

The reading order for the style.

shrinkToFit

Specifies if text automatically shrinks to fit in the available column width.

verticalAlignment

Specifies the vertical alignment for the style. See Excel.VerticalAlignment for details.

wrapText

Specifies if Excel wraps the text in the object.

Property Details

borders

A collection of four border objects that represent the style of the four borders.

borders?: Excel.Interfaces.RangeBorderCollectionUpdateData;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

fill

The fill of the style.

fill?: Excel.Interfaces.RangeFillUpdateData;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

font

A Font object that represents the font of the style.

font?: Excel.Interfaces.RangeFontUpdateData;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

formulaHidden

Specifies if the formula will be hidden when the worksheet is protected.

formulaHidden?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

horizontalAlignment

Represents the horizontal alignment for the style. See Excel.HorizontalAlignment for details.

horizontalAlignment?: Excel.HorizontalAlignment | "General" | "Left" | "Center" | "Right" | "Fill" | "Justify" | "CenterAcrossSelection" | "Distributed";

Property Value

Excel.HorizontalAlignment | "General" | "Left" | "Center" | "Right" | "Fill" | "Justify" | "CenterAcrossSelection" | "Distributed"

Remarks

[ API set: ExcelApi 1.7 ]

includeAlignment

Specifies if the style includes the auto indent, horizontal alignment, vertical alignment, wrap text, indent level, and text orientation properties.

includeAlignment?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

includeBorder

Specifies if the style includes the color, color index, line style, and weight border properties.

includeBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

includeFont

Specifies if the style includes the background, bold, color, color index, font style, italic, name, size, strikethrough, subscript, superscript, and underline font properties.

includeFont?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

includeNumber

Specifies if the style includes the number format property.

includeNumber?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

includePatterns

Specifies if the style includes the color, color index, invert if negative, pattern, pattern color, and pattern color index interior properties.

includePatterns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

includeProtection

Specifies if the style includes the formula hidden and locked protection properties.

includeProtection?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

indentLevel

An integer from 0 to 250 that indicates the indent level for the style.

indentLevel?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.7 ]

locked

Specifies if the object is locked when the worksheet is protected.

locked?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

numberFormat

The format code of the number format for the style.

numberFormat?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.7 ]

numberFormatLocal

The localized format code of the number format for the style.

numberFormatLocal?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.7 ]

readingOrder

The reading order for the style.

readingOrder?: Excel.ReadingOrder | "Context" | "LeftToRight" | "RightToLeft";

Property Value

Excel.ReadingOrder | "Context" | "LeftToRight" | "RightToLeft"

Remarks

[ API set: ExcelApi 1.7 ]

shrinkToFit

Specifies if text automatically shrinks to fit in the available column width.

shrinkToFit?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

verticalAlignment

Specifies the vertical alignment for the style. See Excel.VerticalAlignment for details.

verticalAlignment?: Excel.VerticalAlignment | "Top" | "Center" | "Bottom" | "Justify" | "Distributed";

Property Value

Excel.VerticalAlignment | "Top" | "Center" | "Bottom" | "Justify" | "Distributed"

Remarks

[ API set: ExcelApi 1.7 ]

wrapText

Specifies if Excel wraps the text in the object.

wrapText?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]