次の方法で共有


PivotChange Class

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

Inheritance Hierarchy

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

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

Syntax

'宣言
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(TupleItems), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(PivotEditValue), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ExtensionList), FileFormatVersions.Office2010)> _
Public Class PivotChange _
    Inherits OpenXmlCompositeElement
'使用
Dim instance As PivotChange
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(TupleItems), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(PivotEditValue), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ExtensionList), FileFormatVersions.Office2010)]
public class PivotChange : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • PivotEditValue <x14:editValue>

  • TupleItems <x14:tupleItems>

  • ExtensionList <x14:extLst>

2.6.40 CT_PivotChange

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

Referenced by: CT_PivotChanges

A complex type that specifies the value used for PivotTable what-if analysis calculation and specifies the allocation method for how to apply the value. It also specifies a collection of MDX unique names that identifies the original value in the OLAP data source that was changed.

Child Elements:

editValue : A CT_PivotEditValue element that specifies the value that replaces the original value in the OLAP data source for PivotTable what-if analysis.

tupleItems : A CT_TupleItems element that specifies the MDX unique names that identify the value in the OLAP data source that was changed using PivotTable what-if analysis.

pivotArea : MUST NOT exist, and MUST be ignored.<35>

extLst : A CT_ExtensionList ([ISO/IEC-29500-4] section A.2) that specifies future extensibility for this element.

Attributes:

allocationMethod : An ST_AllocationMethod attribute that specifies the allocation method, used by PivotTable what-if analysis, to change the value in the OLAP data source.<36>

weightExpression : An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the OLAP weight expression for PivotTable what-if analysis. The weightExpression MUST exist if and only if allocationMethod equals weightedAllocation or equals weightedIncrement. The weightExpression MUST be greater than zero and less than or equal to 65535 characters in length.

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

<xsd:complexType name="CT_PivotChange">

<xsd:sequence>

<xsd:element name="editValue" type="CT_PivotEditValue" minOccurs="1" maxOccurs="1"/>

<xsd:element name="tupleItems" type="CT_TupleItems" minOccurs="1" maxOccurs="1"/>

<xsd:element name="pivotArea" type="x:CT_PivotArea" minOccurs="0" maxOccurs="1"/>

<xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="allocationMethod" type="ST_AllocationMethod" default="equalAllocation"/>

<xsd:attribute name="weightExpression" type="x:ST_Xstring" use="optional"/>

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

PivotChange Members

DocumentFormat.OpenXml.Office2010.Excel Namespace