CellStyleObject module

class CellStyleObject.CellStyleObject

Bases: SpireObject, IStyle

BeginUpdate()

property Borders: IBorders

property BuiltIn: bool

<summary>: True if the style is a built-in style.

</summary>

property Color: Color

<summary>: Gets or sets the cell shading color.

</summary>

EndUpdate()

property FillPattern: ExcelPatternType

<summary>: Gets or Sets fill pattern type.

</summary>

property Font: IFont

property FormulaHidden: bool

<summary>: True if the formula will be hidden when the worksheet is protected.

</summary>

property HorizontalAlignment: HorizontalAlignType

<summary>: Returns or sets the horizontal alignment for the specified object.

</summary>

property IncludeAlignment: bool

<summary>

True if the style includes the AddIndent, HorizontalAlignment,: VerticalAlignment, WrapText, and Orientation properties.

</summary>

property IncludeBorder: bool

<summary>: True if the style includes the Color, KnownColor, LineStyle, and Weight border properties

</summary>

property IncludeFont: bool

<summary>: True if the style includes the Background, Bold, Color, KnownColor, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties.

</summary>

property IncludeNumberFormat: bool

<summary>: True if the style includes the NumberFormat property.

</summary>

property IncludePatterns: bool

<summary>

True if the style includes the Color, KnownColor,: InvertIfNegative, Pattern, PatternColor, and PatternKnownColor interior properties.

</summary>

property IncludeProtection: bool

<summary>

True if the style includes the FormulaHidden and Locked protection: properties.

</summary>

property IndentLevel: int

<summary>: Returns or sets the indent level for the style.

</summary>

property Interior: IInterior

property IsFirstSymbolApostrophe: bool

<summary>: If true then first symbol in cell is apostrophe.

</summary>

property IsInitialized: bool

property IsModified: bool

property JustifyLast: bool

<summary>: Represents justify text alignment

</summary>

property KnownColor: ExcelColors

<summary>: Gets or sets the cell shading excel color.

</summary>

property Locked: bool

<summary>: True if the object is locked; False if the object can be modified when the sheet is protected.

</summary>

property Name: str

<summary>: Returns or sets the name of the object. Read-only String.

</summary>

property NumberFormat: str

<summary>: Returns or sets the format code for the object.

</summary>

property NumberFormatIndex: int

<summary>: Gets or Sets format index.

</summary>

property NumberFormatLocal: str

<summary>

Returns or sets the format code for the object as a string in the: language of the user.

</summary>

property NumberFormatSettings: INumberFormat

property Parent: SpireObject

property PatternColor: Color

<summary>: Returns or sets the color of the interior pattern.

</summary>

property PatternKnownColor: ExcelColors

<summary>: Returns or sets the excel color of the interior.

</summary>

property ReadingOrder: ReadingOrderType

<summary>: Returns or sets the reading order for the specified object.

</summary>

property Rotation: int

<summary>: The text orientation. Can be an integer value from 1 to 180 degrees

</summary>

SetThemeColor(type: ThemeColorType, tint: float)

<summary>: Set the theme color.

</summary> <param name=”type”>theme color type</param> <param name=”tint”></param>

property ShrinkToFit: bool

<summary>: True if text automatically shrinks to fit in the available column width.

</summary>

property VerticalAlignment: VerticalAlignType

<summary>: Returns or sets the vertical alignment of the specified object.

</summary>

property WrapText: bool

<summary>: True if Microsoft Excel wraps the text in the object.

</summary>