Excel.Interfaces.StyleCollectionLoadOptions interface
Represents a collection of all the styles.
Remarks
Properties
$all | Specifying |
auto |
For EACH ITEM in the collection: Specifies if text is automatically indented when the text alignment in a cell is set to equal distribution. |
borders | For EACH ITEM in the collection: A collection of four border objects that represent the style of the four borders. |
built |
For EACH ITEM in the collection: Specifies if the style is a built-in style. |
fill | For EACH ITEM in the collection: The fill of the style. |
font | For EACH ITEM in the collection: A |
formula |
For EACH ITEM in the collection: Specifies if the formula will be hidden when the worksheet is protected. |
horizontal |
For EACH ITEM in the collection: Represents the horizontal alignment for the style. See |
include |
For EACH ITEM in the collection: Specifies if the style includes the auto indent, horizontal alignment, vertical alignment, wrap text, indent level, and text orientation properties. |
include |
For EACH ITEM in the collection: Specifies if the style includes the color, color index, line style, and weight border properties. |
include |
For EACH ITEM in the collection: Specifies if the style includes the background, bold, color, color index, font style, italic, name, size, strikethrough, subscript, superscript, and underline font properties. |
include |
For EACH ITEM in the collection: Specifies if the style includes the number format property. |
include |
For EACH ITEM in the collection: Specifies if the style includes the color, color index, invert if negative, pattern, pattern color, and pattern color index interior properties. |
include |
For EACH ITEM in the collection: Specifies if the style includes the formula hidden and locked protection properties. |
indent |
For EACH ITEM in the collection: An integer from 0 to 250 that indicates the indent level for the style. |
locked | For EACH ITEM in the collection: Specifies if the object is locked when the worksheet is protected. |
name | For EACH ITEM in the collection: The name of the style. |
number |
For EACH ITEM in the collection: The format code of the number format for the style. |
number |
For EACH ITEM in the collection: The localized format code of the number format for the style. |
reading |
For EACH ITEM in the collection: The reading order for the style. |
shrink |
For EACH ITEM in the collection: Specifies if text automatically shrinks to fit in the available column width. |
text |
For EACH ITEM in the collection: The text orientation for the style. |
vertical |
For EACH ITEM in the collection: Specifies the vertical alignment for the style. See |
wrap |
For EACH ITEM in the collection: Specifies if Excel wraps the text in the object. |
Property Details
$all
Specifying $all
for the LoadOptions loads all the scalar properties (e.g.: Range.address
) but not the navigational properties (e.g.: Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
autoIndent
For EACH ITEM in the collection: Specifies if text is automatically indented when the text alignment in a cell is set to equal distribution.
autoIndent?: boolean;
Property Value
boolean
Remarks
borders
For EACH ITEM in the collection: A collection of four border objects that represent the style of the four borders.
borders?: Excel.Interfaces.RangeBorderCollectionLoadOptions;
Property Value
Remarks
builtIn
For EACH ITEM in the collection: Specifies if the style is a built-in style.
builtIn?: boolean;
Property Value
boolean
Remarks
fill
For EACH ITEM in the collection: The fill of the style.
fill?: Excel.Interfaces.RangeFillLoadOptions;
Property Value
Remarks
font
For EACH ITEM in the collection: A Font
object that represents the font of the style.
font?: Excel.Interfaces.RangeFontLoadOptions;
Property Value
Remarks
formulaHidden
For EACH ITEM in the collection: Specifies if the formula will be hidden when the worksheet is protected.
formulaHidden?: boolean;
Property Value
boolean
Remarks
horizontalAlignment
For EACH ITEM in the collection: Represents the horizontal alignment for the style. See Excel.HorizontalAlignment
for details.
horizontalAlignment?: boolean;
Property Value
boolean
Remarks
includeAlignment
For EACH ITEM in the collection: 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
includeBorder
For EACH ITEM in the collection: Specifies if the style includes the color, color index, line style, and weight border properties.
includeBorder?: boolean;
Property Value
boolean
Remarks
includeFont
For EACH ITEM in the collection: 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
includeNumber
For EACH ITEM in the collection: Specifies if the style includes the number format property.
includeNumber?: boolean;
Property Value
boolean
Remarks
includePatterns
For EACH ITEM in the collection: 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
includeProtection
For EACH ITEM in the collection: Specifies if the style includes the formula hidden and locked protection properties.
includeProtection?: boolean;
Property Value
boolean
Remarks
indentLevel
For EACH ITEM in the collection: An integer from 0 to 250 that indicates the indent level for the style.
indentLevel?: boolean;
Property Value
boolean
Remarks
locked
For EACH ITEM in the collection: Specifies if the object is locked when the worksheet is protected.
locked?: boolean;
Property Value
boolean
Remarks
name
For EACH ITEM in the collection: The name of the style.
name?: boolean;
Property Value
boolean
Remarks
numberFormat
For EACH ITEM in the collection: The format code of the number format for the style.
numberFormat?: boolean;
Property Value
boolean
Remarks
numberFormatLocal
For EACH ITEM in the collection: The localized format code of the number format for the style.
numberFormatLocal?: boolean;
Property Value
boolean
Remarks
readingOrder
For EACH ITEM in the collection: The reading order for the style.
readingOrder?: boolean;
Property Value
boolean
Remarks
shrinkToFit
For EACH ITEM in the collection: Specifies if text automatically shrinks to fit in the available column width.
shrinkToFit?: boolean;
Property Value
boolean
Remarks
textOrientation
For EACH ITEM in the collection: The text orientation for the style.
textOrientation?: boolean;
Property Value
boolean
Remarks
verticalAlignment
For EACH ITEM in the collection: Specifies the vertical alignment for the style. See Excel.VerticalAlignment
for details.
verticalAlignment?: boolean;
Property Value
boolean
Remarks
wrapText
For EACH ITEM in the collection: Specifies if Excel wraps the text in the object.
wrapText?: boolean;
Property Value
boolean
Remarks
Office Add-ins