Click or drag to resize

CellStyle Class

Represents the style of the cell range.
Examples
The following code illustrates how to the style of the specified range:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Set text</para><para>worksheet["C2"].Text = "Sample";</para><para>//Add and set style</para><para>CellStyle style = workbook.Styles.Add("BorderStyle");</para><para>style.Color = Color.Red;</para><para>worksheet["C2"].Style = style;</para><para>//Save to file</para><para>workbook.SaveToFile("Style.xlsx");</para>
Inheritance Hierarchy
System Object
Spire.Xls CellStyleObject
Spire.Xls CellStyle

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class CellStyle : CellStyleObject

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
Methods
Name Description
Public method BeginUpdate
This method should be called before several updates to the object will take place.
(Inherited from CellStyleObject .)
Public method clone
clone CellStyle
Public method clone(Workbook)
clone CellStyle and add to book.Styles
Public method EndUpdate
This method should be called after several updates to the object took place.
(Inherited from CellStyleObject .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetThemeColor
Get the theme color.
(Inherited from CellStyleObject .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method SetThemeColor
Set the theme color.
(Inherited from CellStyleObject .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also