CellStyle-Klasse
Cell Style.When the object is serialized out as xml, its qualified name is x:cellStyle.
Vererbungshierarchie
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.CellStyle
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class CellStyle _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As CellStyle
[ChildElementInfoAttribute(typeof(ExtensionList))]
public class CellStyle : OpenXmlCompositeElement
Hinweise
The following table lists the possible child types:
- ExtensionList <x:extLst>
[ISO/IEC 29500-1 1. Ausgabe]
18.8.7 cellStyle (Cell Style)
This element represents the name and related formatting records for a named cell style in this workbook.
Annex H contains a listing of cellStyles whose corresponding formatting records are implied rather than explicitly saved in the file. In this case, a builtinId attribute is written on the cellStyle record, but no corresponding formatting records are written.
For all built-in cell styles, the builtinId determines the style, not the name. For all cell styles, Normal is applied by default.
Parent Elements |
---|
cellStyles (§18.8.8) |
Child Elements |
Subclause |
---|---|
extLst (Future Feature Data Storage Area) |
§18.2.10 |
Attributes |
Description |
---|---|
builtinId (Built-In Style Id) |
The index of a built-in cell style: The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
customBuiltin (Custom Built In) |
True indicates that this built-in cell style has been customized. By default built-in styles are not persisted when not in use. This flag indicates that a built-in style has been modified, and therefore should be saved with the workbook, even if not currently in use. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
hidden (Hidden Style) |
If 'true' do not show this style in the application UI. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
iLevel (Outline Style) |
Indicates that this formatting is for an outline style . When styles are applied to outline levels (using the outline feature), this value is set and the formatting specified on this cell style is applied to the corresponding level of the outline. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
name (User Defined Cell Style) |
The name of the cell style. The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19). |
xfId (Format Id) |
Zero-based index referencing an xf record in the cellStyleXfs collection. This is used to determine the formatting defined for this named cell style. The possible values for this attribute are defined by the ST_CellStyleXfId simple type (§18.18.10). |
[Note: The W3C XML Schema definition of this element's content model (CT_CellStyle) is located in §A.2. end note]
© ISO/IEC29500: 2008. Die oben aufgeführten Textauszüge wurden von Microsoft (und/oder den Microsoft-Vendoren) von Englisch nach Deutsch übersetzt, und im Rahmen von ISO wird keinerlei Verantwortung für diese Übersetzungen übernommen.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic) Member dieses Typs sind threadsicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.