Slicers class

Office 2013 and later

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

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.4.36 slicers

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

A slicers element is a CT_Slicers type element, as specified in section 2.6.67, that specifies all the slicer views, as specified in section 2.3.2.2, on the sheet (1). This element is the root element of the slicers part, as specified in section 2.3.2.

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.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.67 CT_Slicers

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: slicers

A complex type that specifies a list of CT_Slicer elements, as specified in section 2.6.69. 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.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: