Partager via


SlicerStyle Class

Defines the SlicerStyle Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:slicerStyle.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.SlicerStyle

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(SlicerStyleElements), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class SlicerStyle _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As SlicerStyle
[ChildElementInfoAttribute(typeof(SlicerStyleElements), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class SlicerStyle : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • SlicerStyleElements <x14:slicerStyleElements>

2.6.44 CT_SlicerStyle

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: CT_SlicerStyles

This specifies table style ([ISO/IEC-29500-1] section 18.8) elements of the slicer style that are specific to slicers.

Child Elements:

slicerStyleElements : A CT_SlicerStyleElements that specifies table style ([ISO/IEC-29500-1] section 18.8) elements of the slicer style that are specific to slicers. There MUST NOT be more than one CT_SlicerStyleElements in this element.

Attributes:

name : A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the user-defined table style ([ISO/IEC-29500-1] section 18.8) that this slicer style is based upon. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters. This string MUST be unique within the CT SlicerStyle elements in the Styles part ([ISO/IEC-29500-1] section 12.3.20). This string MUST match the name attribute of a CT_TableStyle ([ISO/IEC-29500-4] section A.2) element in the Styles part ([ISO/IEC-29500-1] section 12.3.20). In the CT_TableStyle ([ISO/IEC-29500-4] section A.2) element with a name attribute that matches this string, the pivot attribute MUST equal FALSE and the table attribute MUST equal FALSE.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_SlicerStyle">

<xsd:sequence>

<xsd:element name="slicerStyleElements" type="CT_SlicerStyleElements" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="name" type="xsd:string" use="required"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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

SlicerStyle Members

DocumentFormat.OpenXml.Office2010.Excel Namespace