Click or drag to resize

XlsStyle Class

Represents a style for cells in an Excel worksheet, inheriting from AddtionalFormatWrapper and implementing interfaces for comparison, styling, and named object functionality.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet CommonWrapper
Spire.Xls.Core.Spreadsheet AddtionalFormatWrapper
Spire.Xls.Core.Spreadsheet XlsStyle

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class XlsStyle : AddtionalFormatWrapper, IComparable, 
	IStyle, IExtendedFormat, IExcelApplication, IOptimizedUpdate, INamedObject

The XlsStyle type exposes the following members.

Properties
Name Description
Public property BackgroundColor
Gets or sets the background color of the cell.
(Inherited from AddtionalFormatWrapper .)
Public property BackgroundKnownColor
Gets or sets the background known color of the cell.
(Inherited from AddtionalFormatWrapper .)
Protected property BeginCallsCount
Returns number of begin update calls that have no corresponding end update. Read-only.
(Inherited from CommonWrapper .)
Public property Borders
Gets the borders associated with the cell.
(Inherited from AddtionalFormatWrapper .)
Public property BottomBorderColor
Gets the bottom border color of the style.
(Inherited from AddtionalFormatWrapper .)
Public property BottomBorderLineStyle
Gets or sets the line style of the bottom border.
(Inherited from AddtionalFormatWrapper .)
Public property BuiltIn
Gets a value indicating whether the object is built-in.
Public property Color
Gets or sets the color of the style.
(Inherited from AddtionalFormatWrapper .)
Public property DiagonalBorderColor
Gets the color of the diagonal border.
(Inherited from AddtionalFormatWrapper .)
Public property DiagonalDownBorderLineStyle
Gets or sets the line style of the diagonal down border.
(Inherited from AddtionalFormatWrapper .)
Public property DiagonalDownVisible
Gets or sets the visibility of the diagonal line starting from the top-left corner.
(Inherited from AddtionalFormatWrapper .)
Public property DiagonalUpBorderLineStyle
Gets or sets the line style of the diagonal up border.
(Inherited from AddtionalFormatWrapper .)
Public property DiagonalUpVisible
Gets or sets the visibility of the diagonal line from the bottom left to the top right.
(Inherited from AddtionalFormatWrapper .)
Public property ExtendedFormatIndex
Gets the index of the extended format.
(Inherited from AddtionalFormatWrapper .)
Public property FillPattern
Gets or sets the fill pattern of the cell.
(Inherited from AddtionalFormatWrapper .)
Public property Font
Gets the font associated with the current style.
(Inherited from AddtionalFormatWrapper .)
Public property ForegroundColor
Gets or sets the foreground color of the cell.
(Inherited from AddtionalFormatWrapper .)
Public property ForegroundKnownColor
Gets or sets the foreground color of the cell.
(Inherited from AddtionalFormatWrapper .)
Public property FormulaHidden
Gets or sets whether the formula is hidden.
(Inherited from AddtionalFormatWrapper .)
Public property HorizontalAlignment
Gets or sets the horizontal alignment of the text in the cell.
(Inherited from AddtionalFormatWrapper .)
Public property IncludeAlignment
Gets or sets a value indicating whether alignment is included.
(Inherited from AddtionalFormatWrapper .)
Public property IncludeBorder
Gets or sets a value indicating whether to include borders in the style.
(Inherited from AddtionalFormatWrapper .)
Public property IncludeFont
Gets or sets a value indicating whether the font is included.
(Inherited from AddtionalFormatWrapper .)
Public property IncludeNumberFormat
Gets or sets a value indicating whether the number format is included.
(Inherited from AddtionalFormatWrapper .)
Public property IncludePatterns
Gets or sets a value indicating whether patterns are included.
(Inherited from AddtionalFormatWrapper .)
Public property IncludeProtection
Gets or sets a value indicating whether protection is included.
(Inherited from AddtionalFormatWrapper .)
Public property IndentLevel
Gets or sets the indentation level of the style converter.
(Inherited from AddtionalFormatWrapper .)
Public property Index
Gets the xfIndex of the item.
Public property Interior
Gets the interior style of the cell.
(Inherited from AddtionalFormatWrapper .)
Public property IsFirstSymbolApostrophe
Gets or sets a value indicating whether the first symbol is an apostrophe.
(Inherited from AddtionalFormatWrapper .)
Public property IsInitialized
Gets a value indicating whether the current style is initialized and different from the default style.
Public property IsModified
Gets a value indicating whether the current style has been modified.
(Inherited from AddtionalFormatWrapper .)
Public property JustifyLast
Gets or sets a value indicating whether the last item should be justified.
(Inherited from AddtionalFormatWrapper .)
Public property KnownColor
Gets or sets the known color of the foreground.
(Inherited from AddtionalFormatWrapper .)
Public property LeftBorderColor
Gets the left border color of the object.
(Inherited from AddtionalFormatWrapper .)
Public property LeftBorderLineStyle
Gets or sets the line style of the left border.
(Inherited from AddtionalFormatWrapper .)
Public property Locked
Gets or sets a value indicating whether the style converter is locked.
(Inherited from AddtionalFormatWrapper .)
Public property Name
Gets the name of the entity, returning the name from the base class.
Public property NumberFormat
Gets or sets the number format string for the cell.
(Inherited from AddtionalFormatWrapper .)
Public property NumberFormatIndex
Gets or sets the index of the number format.
(Inherited from AddtionalFormatWrapper .)
Public property NumberFormatLocal
Gets or sets the number format.
(Inherited from AddtionalFormatWrapper .)
Public property NumberFormatSettings
Gets the number format settings for the specified number format index.
(Inherited from AddtionalFormatWrapper .)
Public property Parent
Gets the parent object, which is typically a book in this context.
(Inherited from AddtionalFormatWrapper .)
Public property PatternColor
Gets or sets the pattern color of the style.
(Inherited from AddtionalFormatWrapper .)
Public property PatternKnownColor
Gets or sets the known color of the pattern.
(Inherited from AddtionalFormatWrapper .)
Public property ReadingOrder
Gets or sets the reading order of the text.
(Inherited from AddtionalFormatWrapper .)
Public property RightBorderColor
Gets the right border color of the style.
(Inherited from AddtionalFormatWrapper .)
Public property RightBorderLineStyle
Gets or sets the line style of the right border of the cell.
(Inherited from AddtionalFormatWrapper .)
Public property Rotation
Gets or sets the rotation angle of the style.
(Inherited from AddtionalFormatWrapper .)
Public property ShrinkToFit
Gets or sets a value indicating whether the control should shrink to fit its content.
(Inherited from AddtionalFormatWrapper .)
Public property TopBorderColor
Gets the top border color of the style.
(Inherited from AddtionalFormatWrapper .)
Public property TopBorderLineStyle
Gets or sets the line style of the top border.
(Inherited from AddtionalFormatWrapper .)
Public property VerticalAlignment
Gets or sets the vertical alignment of the text in the cell.
(Inherited from AddtionalFormatWrapper .)
Public property Workbook
Gets the workbook associated with the current spreadsheet.
(Inherited from AddtionalFormatWrapper .)
Public property WrapText
Gets or sets a value indicating whether text is wrapped within a cell.
(Inherited from AddtionalFormatWrapper .)
Top
Methods
Name Description
Public method BeginUpdate
Begins the update process for the control.This method should be called before several updates to the object will take place.
(Overrides AddtionalFormatWrapper BeginUpdate .)
Public method Clone
Creates a new object that is a copy of the current instance.
(Overrides AddtionalFormatWrapper Clone(Object) .)
Public method CompareTo
Compares the current XlsStyle instance with another object to determine their relative order.
Public method EndUpdate
Ends the update process, making the control available for interaction.This method should be called after several updates to the object took place.
(Overrides AddtionalFormatWrapper EndUpdate .)
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 GetBackgroundThemeColor
Retrieves the background theme color and its tint.
(Inherited from AddtionalFormatWrapper .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetThemeColor
Retrieves the theme color and tint for the current style.
(Inherited from AddtionalFormatWrapper .)
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 SetBackgroundThemeColor
Sets the background theme color for the style.
(Inherited from AddtionalFormatWrapper .)
Public method SetThemeColor
Sets the theme color for the foreground.
(Inherited from AddtionalFormatWrapper .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Fields
Name Description
Public field Static member DEF_DEFAULT_STYLES
Represents a static array of strings that contains default style definitions.
Protected field m_book
Represents the workbook object.
(Inherited from AddtionalFormatWrapper .)
Top
See Also