Click or drag to resize

CellStyle Properties

The CellStyle type exposes the following members.

Properties
Name Description
Public property Borders
Returns a Borders collection that represents the borders of a style.
Public property BuiltIn
True if the style is a built-in style.
(Inherited from CellStyleObject .)
Public property Color
Gets or sets the cell shading color.
(Inherited from CellStyleObject .)
Public property FillPattern
Gets or Sets fill pattern type.
(Inherited from CellStyleObject .)
Public property Font
Returns a Font object that represents the font of the specified object.
Public property FormulaHidden
True if the formula will be hidden when the worksheet is protected.
(Inherited from CellStyleObject .)
Public property HorizontalAlignment
Returns or sets the horizontal alignment for the specified object.
(Inherited from CellStyleObject .)
Public property IncludeAlignment
True if the style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties.
(Inherited from CellStyleObject .)
Public property IncludeBorder
True if the style includes the Color, KnownColor, LineStyle, and Weight border properties
(Inherited from CellStyleObject .)
Public property IncludeFont
True if the style includes the Background, Bold, Color, KnownColor, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties.
(Inherited from CellStyleObject .)
Public property IncludeNumberFormat
True if the style includes the NumberFormat property.
(Inherited from CellStyleObject .)
Public property IncludePatterns
True if the style includes the Color, KnownColor, InvertIfNegative, Pattern, PatternColor, and PatternKnownColor interior properties.
(Inherited from CellStyleObject .)
Public property IncludeProtection
True if the style includes the FormulaHidden and Locked protection properties.
(Inherited from CellStyleObject .)
Public property IndentLevel
Returns or sets the indent level for the style.
(Inherited from CellStyleObject .)
Public property Interior
Returns interior object for extended format.
Public property IsFirstSymbolApostrophe
If true then first symbol in cell is apostrophe.
(Inherited from CellStyleObject .)
Public property IsInitialized
Indicates whether style is initialized (differs from Normal style). Read-only.
(Inherited from CellStyleObject .)
Public property IsModified
Returns the style has been modified
(Inherited from CellStyleObject .)
Public property JustifyLast
Represents justify text alignment
(Inherited from CellStyleObject .)
Public property KnownColor
Gets or sets the cell shading excel color.
(Inherited from CellStyleObject .)
Public property Locked
True if the object is locked; False if the object can be modified when the sheet is protected.
(Inherited from CellStyleObject .)
Public property Name
Returns or sets the name of the object. Read-only String.
(Inherited from CellStyleObject .)
Public property NumberFormat
Returns or sets the format code for the object.
(Inherited from CellStyleObject .)
Public property NumberFormatIndex
Gets or Sets format index.
(Inherited from CellStyleObject .)
Public property NumberFormatLocal
Returns or sets the format code for the object as a string in the language of the user.
(Inherited from CellStyleObject .)
Public property NumberFormatSettings
Returns object that describes number format. Read-only.
(Inherited from CellStyleObject .)
Public property Parent
Get the parent.
(Inherited from CellStyleObject .)
Public property PatternColor
Returns or sets the color of the interior pattern.
(Inherited from CellStyleObject .)
Public property PatternKnownColor
Returns or sets the excel color of the interior.
(Inherited from CellStyleObject .)
Public property ReadingOrder
Returns or sets the reading order for the specified object.
(Inherited from CellStyleObject .)
Public property Rotation
The text orientation. Can be an integer value from 1 to 180 degrees
(Inherited from CellStyleObject .)
Public property ShrinkToFit
True if text automatically shrinks to fit in the available column width.
(Inherited from CellStyleObject .)
Public property VerticalAlignment
Returns or sets the vertical alignment of the specified object.
(Inherited from CellStyleObject .)
Public property WrapText
True if Microsoft Excel wraps the text in the object.
(Inherited from CellStyleObject .)
Top
See Also