Export (0) Print
Expand All

SlicerList class

Defines the SlicerList Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:slicerList.

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

[ChildElementInfoAttribute(typeof(SlicerRef), FileFormatVersions.None|FileFormatVersions.Office2010|FileFormatVersions.Office2013)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class SlicerList : OpenXmlCompositeElement

2.4.9 slicerList

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

A slicerList element is a CT_SlicerRefs type element, as specified in section 2.6.11, that specifies a list of slicer, as specified in section 2.3.2, part identifiers for the worksheet. See section 2.2.4.11 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].

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

<xsd:element name="slicerList" type="CT_SlicerRefs"/>

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

2.6.11 CT_SlicerRefs

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

Referenced by: slicerList

CT_SlicerRefs is a complex type that specifies a list of slicer (section 2.3.2) part identifiers for the worksheet. MUST contain exactly one slicer part identifier.

Child Elements:

slicer: A CT_SlicerRef element (section 2.6.12) that specifies the slicer part identifier for the worksheet.

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

<xsd:complexType name="CT_SlicerRefs">

<xsd:sequence>

<xsd:element name="slicer" type="CT_SlicerRef" 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:
© 2015 Microsoft