Excel.Interfaces.StyleCollectionLoadOptions interface

代表所有样式的集合。Represents a collection of all the styles.

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

属性

$all
autoIndent

对于集合中的每一项: 指示当单元格中文本的对齐方式设置为相等分布时, 文本是否自动缩进。For EACH ITEM in the collection: 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 对象的边框集合。For EACH ITEM in the collection: A Border collection of four Border objects that represent the style of the four borders.

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

builtIn

对于集合中的每一项: 指示样式是否为内置样式。For EACH ITEM in the collection: Indicates if the style is a built-in style.

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

fill

对于集合中的每个项目: 样式的填充。For EACH ITEM in the collection: The Fill of the style.

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

font

对于集合中的每一项: 一个代表样式的字体的 font 对象。For EACH ITEM in the collection: A Font object that represents the font of the style.

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

formulaHidden

对于集合中的每一项: 指示工作表受保护时是否隐藏公式。For EACH ITEM in the collection: Indicates if the formula will be hidden when the worksheet is protected.

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

horizontalAlignment

对于集合中的每一项: 表示样式的水平对齐方式。For EACH ITEM in the collection: 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 属性。For EACH ITEM in the collection: 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 和权数边框属性。For EACH ITEM in the collection: Indicates if the style includes the Color, ColorIndex, LineStyle, and Weight border properties.

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

includeFont

对于集合中的每一项: 指示样式是否包括背景、粗体、颜色、ColorIndex、FontStyle、斜体、名称、大小、删除线、下标、上标和下划线字体属性。For EACH ITEM in the collection: 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 属性。For EACH ITEM in the collection: Indicates if the style includes the NumberFormat property.

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

includePatterns

对于集合中的每一项: 指示样式是否包含 Color、ColorIndex、InvertIfNegative、Pattern、PatternColor 和 PatternColorIndex 内部属性。For EACH ITEM in the collection: 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 和锁定保护属性。For EACH ITEM in the collection: Indicates if the style includes the FormulaHidden and Locked protection properties.

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

indentLevel

对于集合中的每一项: 一个介于0到250之间的整数, 它指示样式的缩进量级别。For EACH ITEM in the collection: An integer from 0 to 250 that indicates the indent level for the style.

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

locked

对于集合中的每一项: 指示在工作表处于保护状态时是否锁定对象。For EACH ITEM in the collection: Indicates if the object is locked when the worksheet is protected.

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

name

对于集合中的每个项目: 样式的名称。For EACH ITEM in the collection: The name of the style.

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

numberFormat

对于集合中的每一项: 样式的数字格式的格式代码。For EACH ITEM in the collection: The format code of the number format for the style.

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

numberFormatLocal

对于集合中的每一项: 样式的数字格式的本地化格式代码。For EACH ITEM in the collection: The localized format code of the number format for the style.

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

readingOrder

对于集合中的每一项: 样式的阅读顺序。For EACH ITEM in the collection: The reading order for the style.

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

shrinkToFit

对于集合中的每一项: 指示文本是否自动缩小以适合可用列宽。For EACH ITEM in the collection: Indicates if text automatically shrinks to fit in the available column width.

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

textOrientation

对于集合中的每一项: 样式的文本方向。For EACH ITEM in the collection: The text orientation for the style.

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

verticalAlignment

对于集合中的每一项: 表示样式的垂直对齐方式。For EACH ITEM in the collection: 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 是否对对象中的文本进行换行。For EACH ITEM in the collection: Indicates if Microsoft Excel wraps the text in the object.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

autoIndent

对于集合中的每一项: 指示当单元格中文本的对齐方式设置为相等分布时, 文本是否自动缩进。For EACH ITEM in the collection: 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 对象的边框集合。For EACH ITEM in the collection: 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.RangeBorderCollectionLoadOptions;

属性值

builtIn

对于集合中的每一项: 指示样式是否为内置样式。For EACH ITEM in the collection: Indicates if the style is a built-in style.

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

builtIn?: boolean;

属性值

boolean

fill

对于集合中的每个项目: 样式的填充。For EACH ITEM in the collection: The Fill of the style.

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

fill?: Excel.Interfaces.RangeFillLoadOptions;

属性值

font

对于集合中的每一项: 一个代表样式的字体的 font 对象。For EACH ITEM in the collection: A Font object that represents the font of the style.

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

font?: Excel.Interfaces.RangeFontLoadOptions;

属性值

formulaHidden

对于集合中的每一项: 指示工作表受保护时是否隐藏公式。For EACH ITEM in the collection: 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

对于集合中的每一项: 表示样式的水平对齐方式。For EACH ITEM in the collection: Represents the horizontal alignment for the style. 有关详细信息, 请参阅 HorizontalAlignment。See Excel.HorizontalAlignment for details.

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

horizontalAlignment?: boolean;

属性值

boolean

includeAlignment

对于集合中的每一项: 指示样式是否包括 AutoIndent、HorizontalAlignment、VerticalAlignment、WrapText、IndentLevel 和 TextOrientation 属性。For EACH ITEM in the collection: 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 和权数边框属性。For EACH ITEM in the collection: 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

对于集合中的每一项: 指示样式是否包括背景、粗体、颜色、ColorIndex、FontStyle、斜体、名称、大小、删除线、下标、上标和下划线字体属性。For EACH ITEM in the collection: 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 属性。For EACH ITEM in the collection: 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 内部属性。For EACH ITEM in the collection: 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 和锁定保护属性。For EACH ITEM in the collection: 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之间的整数, 它指示样式的缩进量级别。For EACH ITEM in the collection: An integer from 0 to 250 that indicates the indent level for the style.

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

indentLevel?: boolean;

属性值

boolean

locked

对于集合中的每一项: 指示在工作表处于保护状态时是否锁定对象。For EACH ITEM in the collection: Indicates if the object is locked when the worksheet is protected.

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

locked?: boolean;

属性值

boolean

name

对于集合中的每个项目: 样式的名称。For EACH ITEM in the collection: The name of the style.

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

name?: boolean;

属性值

boolean

numberFormat

对于集合中的每一项: 样式的数字格式的格式代码。For EACH ITEM in the collection: The format code of the number format for the style.

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

numberFormat?: boolean;

属性值

boolean

numberFormatLocal

对于集合中的每一项: 样式的数字格式的本地化格式代码。For EACH ITEM in the collection: The localized format code of the number format for the style.

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

numberFormatLocal?: boolean;

属性值

boolean

readingOrder

对于集合中的每一项: 样式的阅读顺序。For EACH ITEM in the collection: The reading order for the style.

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

readingOrder?: boolean;

属性值

boolean

shrinkToFit

对于集合中的每一项: 指示文本是否自动缩小以适合可用列宽。For EACH ITEM in the collection: 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

对于集合中的每一项: 样式的文本方向。For EACH ITEM in the collection: The text orientation for the style.

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

textOrientation?: boolean;

属性值

boolean

verticalAlignment

对于集合中的每一项: 表示样式的垂直对齐方式。For EACH ITEM in the collection: Represents the vertical alignment for the style. 有关详细信息, 请参阅 VerticalAlignment。See Excel.VerticalAlignment for details.

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

verticalAlignment?: boolean;

属性值

boolean

wrapText

对于集合中的每一项: 指示 Microsoft Excel 是否对对象中的文本进行换行。For EACH ITEM in the collection: Indicates if Microsoft Excel wraps the text in the object.

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

wrapText?: boolean;

属性值

boolean