Excel.Interfaces.StyleUpdateData interface

用于更新样式对象上的数据的接口, 可用于 "style. set (An interface for updating data on the Style object, for use in "style.set({ ... })".

属性

autoIndent

指示将单元格中的文本对齐方式设为相等分布时文本是否会自动缩进。Indicates if text is automatically indented when the text alignment in a cell is set to equal distribution.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

borders

四个 Border 对象的 Border 集合,表示四个边框的样式。A Border collection of four Border objects that represent the style of the four borders.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

fill

样式的填充。The Fill of the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

font

该 Font 对象表示样式的字体。A Font object that represents the font of the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

formulaHidden

指示工作表受保护时是否隐藏公式。Indicates if the formula will be hidden when the worksheet is protected.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

horizontalAlignment

表示样式水平对齐。Represents the horizontal alignment for the style. 有关详细信息, 请参阅 HorizontalAlignment。See Excel.HorizontalAlignment for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeAlignment

指示样式是否包含 AutoIndent、HorizontalAlignment、VerticalAlignment、WrapText、IndentLevel 和 TextOrientation 属性。Indicates if the style includes the AutoIndent, HorizontalAlignment, VerticalAlignment, WrapText, IndentLevel, and TextOrientation properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeBorder

指示样式是否包含 Color、ColorIndex、LineStyle 和 Weight 边框属性。Indicates if the style includes the Color, ColorIndex, LineStyle, and Weight border properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeFont

指示样式是否包含 Background、Bold、Color、ColorIndex、FontStyle、Italic、Name、Size、Strikethrough、Subscrip、Superscript 和 Underline 字体属性。Indicates if the style includes the Background, Bold, Color, ColorIndex, FontStyle, Italic, Name, Size, Strikethrough, Subscript, Superscript, and Underline font properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeNumber

指示样式是否包含 NumberFormat 属性。Indicates if the style includes the NumberFormat property.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includePatterns

指示样式是否包含 Color、ColorIndex、InvertIfNegative、Pattern、PatternColor 和 PatternColorIndex 内部属性。Indicates if the style includes the Color, ColorIndex, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeProtection

指示样式是否包含 FormulaHidden 和 Locked 保护属性。Indicates if the style includes the FormulaHidden and Locked protection properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

indentLevel

0 到 250 之间的一个整数,指示样式的缩进水平。An integer from 0 to 250 that indicates the indent level for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

locked

指示工作表受保护时是否锁定对象。Indicates if the object is locked when the worksheet is protected.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

numberFormat

样式中数字格式的格式代码。The format code of the number format for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

numberFormatLocal

样式中数字格式的本地化格式代码。The localized format code of the number format for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

readingOrder

样式中的阅读顺序。The reading order for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

shrinkToFit

指示文本是否自动缩小以适合可用列宽。Indicates if text automatically shrinks to fit in the available column width.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

textOrientation

此样式中的文本方向。The text orientation for the style.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

verticalAlignment

表示样式的垂直对齐方式。Represents the vertical alignment for the style. 有关详细信息, 请参阅 VerticalAlignment。See Excel.VerticalAlignment for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

wrapText

指示 Microsoft Excel 是否将对象中的文本换行。Indicates if Microsoft Excel wraps the text in the object.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

属性详细信息

autoIndent

指示将单元格中的文本对齐方式设为相等分布时文本是否会自动缩进。Indicates if text is automatically indented when the text alignment in a cell is set to equal distribution.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

autoIndent?: boolean;

属性值

boolean

borders

四个 Border 对象的 Border 集合,表示四个边框的样式。A Border collection of four Border objects that represent the style of the four borders.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

borders?: Excel.Interfaces.RangeBorderCollectionUpdateData;

属性值

fill

样式的填充。The Fill of the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

fill?: Excel.Interfaces.RangeFillUpdateData;

属性值

font

该 Font 对象表示样式的字体。A Font object that represents the font of the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

font?: Excel.Interfaces.RangeFontUpdateData;

属性值

formulaHidden

指示工作表受保护时是否隐藏公式。Indicates if the formula will be hidden when the worksheet is protected.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

formulaHidden?: boolean;

属性值

boolean

horizontalAlignment

表示样式水平对齐。Represents the horizontal alignment for the style. 有关详细信息, 请参阅 HorizontalAlignment。See Excel.HorizontalAlignment for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

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

属性值

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

includeAlignment

指示样式是否包含 AutoIndent、HorizontalAlignment、VerticalAlignment、WrapText、IndentLevel 和 TextOrientation 属性。Indicates if the style includes the AutoIndent, HorizontalAlignment, VerticalAlignment, WrapText, IndentLevel, and TextOrientation properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeAlignment?: boolean;

属性值

boolean

includeBorder

指示样式是否包含 Color、ColorIndex、LineStyle 和 Weight 边框属性。Indicates if the style includes the Color, ColorIndex, LineStyle, and Weight border properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeBorder?: boolean;

属性值

boolean

includeFont

指示样式是否包含 Background、Bold、Color、ColorIndex、FontStyle、Italic、Name、Size、Strikethrough、Subscrip、Superscript 和 Underline 字体属性。Indicates if the style includes the Background, Bold, Color, ColorIndex, FontStyle, Italic, Name, Size, Strikethrough, Subscript, Superscript, and Underline font properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeFont?: boolean;

属性值

boolean

includeNumber

指示样式是否包含 NumberFormat 属性。Indicates if the style includes the NumberFormat property.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeNumber?: boolean;

属性值

boolean

includePatterns

指示样式是否包含 Color、ColorIndex、InvertIfNegative、Pattern、PatternColor 和 PatternColorIndex 内部属性。Indicates if the style includes the Color, ColorIndex, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includePatterns?: boolean;

属性值

boolean

includeProtection

指示样式是否包含 FormulaHidden 和 Locked 保护属性。Indicates if the style includes the FormulaHidden and Locked protection properties.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

includeProtection?: boolean;

属性值

boolean

indentLevel

0 到 250 之间的一个整数,指示样式的缩进水平。An integer from 0 to 250 that indicates the indent level for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

indentLevel?: number;

属性值

number

locked

指示工作表受保护时是否锁定对象。Indicates if the object is locked when the worksheet is protected.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

locked?: boolean;

属性值

boolean

numberFormat

样式中数字格式的格式代码。The format code of the number format for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

numberFormat?: string;

属性值

string

numberFormatLocal

样式中数字格式的本地化格式代码。The localized format code of the number format for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

numberFormatLocal?: string;

属性值

string

readingOrder

样式中的阅读顺序。The reading order for the style.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

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

属性值

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

shrinkToFit

指示文本是否自动缩小以适合可用列宽。Indicates if text automatically shrinks to fit in the available column width.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

shrinkToFit?: boolean;

属性值

boolean

textOrientation

此样式中的文本方向。The text orientation for the style.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

textOrientation?: number;

属性值

number

verticalAlignment

表示样式的垂直对齐方式。Represents the vertical alignment for the style. 有关详细信息, 请参阅 VerticalAlignment。See Excel.VerticalAlignment for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

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

属性值

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

wrapText

指示 Microsoft Excel 是否将对象中的文本换行。Indicates if Microsoft Excel wraps the text in the object.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

wrapText?: boolean;

属性值

boolean