CellStyles Class
Cell Styles.When the object is serialized out as xml, its qualified name is x:cellStyles.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.CellStyles
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(CellStyle))> _
Public Class CellStyles _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As CellStyles
[ChildElementInfoAttribute(typeof(CellStyle))]
public class CellStyles : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- CellStyle <x:cellStyle>
[ISO/IEC 29500-1 1st Edition]
18.8.8 cellStyles (Cell Styles)
This element contains the named cell styles, consisting of a sequence of named style records. A named cell style is a collection of direct or themed formatting (e.g., cell border, cell fill, and font type/size/style) grouped together into a single named style, and can be applied to a cell.
[Example:For example, "Normal", "Heading 1", "Title", and "20% Accent1" are named cell styles expressed below. They have builtInId's associated with them, and use xfId to reference the specific formatting elements pertaining to the particular style. The xfId is a zero-based index, referencing an xf record in the cellStyleXfs collection.
<cellStyles count="4">
<cellStyle name="20% - Accent1" xfId="3" builtinId="30"/>
<cellStyle name="Heading 1" xfId="2" builtinId="16"/>
<cellStyle name="Normal" xfId="0" builtinId="0"/>
<cellStyle name="Title" xfId="1" builtinId="15"/>
</cellStyles>
end example]
Parent Elements |
|---|
styleSheet (§18.8.39) |
Child Elements |
Subclause |
|---|---|
cellStyle (Cell Style) |
§18.8.7 |
Attributes |
Description |
|---|---|
count (Style Count) |
Count of style elements. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_CellStyles) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.