次の方法で共有


CellStyle Class

Cell Style.When the object is serialized out as xml, its qualified name is x:cellStyle.

Inheritance Hierarchy

System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.CellStyle

Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'宣言
<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class CellStyle _
    Inherits OpenXmlCompositeElement
'使用
Dim instance As CellStyle
[ChildElementInfoAttribute(typeof(ExtensionList))]
public class CellStyle : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • ExtensionList <x:extLst>

[ISO/IEC 29500-1 初版]

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. 上記の引用はマイクロソフト (またはその代理) によって英語から日本語に翻訳されたものであり、ISO はこうした翻訳に対する責任を一切負いません。

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.

See Also

Reference

CellStyle Members

DocumentFormat.OpenXml.Spreadsheet Namespace