SetLevel Class

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

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Office2010.Excel.SetLevel

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

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class SetLevel _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As SetLevel
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class SetLevel : OpenXmlLeafElement

Remarks

2.6.23 CT_SetLevel

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

Referenced by: CT_SetLevels

A complex type that specifies an OLAP level of the PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy of a PivotTable ([ISO/IEC-29500-1] section 18.10) named set.

Attributes:

hierarchy : An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies a reference to PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy. MUST be a value from the following table:

Value

Meaning

-2

This specifies that the PivotTable ([ISO/IEC-29500-1] section 18.10) measure cache hierarchy is used.

-1

This specifies that no PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy is used.

greater than or equal to 0

Specifies a zero-based PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy index. The referenced CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) element specifies the PivotTable ([ISO/IEC-29500-1] section 18.10) cache hierarchy that is used. MUST be less than the number of CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) elements within the CT_CacheHierarchies ([ISO/IEC-29500-1] section 18.10) element.

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

<xsd:complexType name="CT_SetLevel">

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

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

SetLevel Members

DocumentFormat.OpenXml.Office2010.Excel Namespace