Slicers Class

Defines the Slicers Class. It is the root element of SlicersPart.When the object is serialized out as xml, its qualified name is x14:slicers.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.OpenXmlPartRootElement
        DocumentFormat.OpenXml.Office2010.Excel.Slicers

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

Syntax

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

Remarks

The following table lists the possible child types:

  • Slicer <x14:slicer>

2.4.31 slicers

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

A CT_Slicers element that specifies all the slicer views on the sheet. This element is the root element of the Slicers part.

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

<xsd:element name="slicers" type="CT_Slicers"/>

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

2.6.61 CT_Slicers

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

Referenced by: slicers

A complex type that specifies a list of CT_Slicer elements. The list of CT_Slicer elements specifies all slicer views on the worksheet.

Child Elements:

slicer : A CT_Slicer element that specifies a slicer view on the worksheet.

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

<xsd:complexType name="CT_Slicers">

<xsd:sequence>

<xsd:element name="slicer" type="CT_Slicer" minOccurs="1" maxOccurs="unbounded"/>

</xsd:sequence>

</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

Slicers Members

DocumentFormat.OpenXml.Office2010.Excel Namespace