Partager via


SlicerStyles Class

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

Inheritance Hierarchy

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

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

Syntax

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

Remarks

The following table lists the possible child types:

  • SlicerStyle <x14:slicerStyle>

2.4.21 slicerStyles

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

A CT_SlicerStyles element that specifies a group of slicer styles. See Styles under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].

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

<xsd:element name="slicerStyles" type="CT_SlicerStyles"/>

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

2.6.51 CT_SlicerStyles

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

Referenced by: slicerStyles

A complex type that specifies a group of slicer styles and the default slicer style to apply to slicers.

Child Elements:

slicerStyle : A CT_SlicerStyle element that specifies a slicer style.

Attributes:

defaultSlicerStyle : A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the default slicer style to apply to slicers. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters.

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

<xsd:complexType name="CT_SlicerStyles">

<xsd:sequence>

<xsd:element name="slicerStyle" type="CT_SlicerStyle" minOccurs="0" maxOccurs="unbounded"/>

</xsd:sequence>

<xsd:attribute name="defaultSlicerStyle" 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

SlicerStyles Members

DocumentFormat.OpenXml.Office2010.Excel Namespace