Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: Element
Name: PivotTable
Namespace: urn:schemas-microsoft-com:office:excel
Type: x:PivotTableType
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information about a PivotTable view.
Collapse XSD Schema Diagram:
Drilldown into PTFormat in schema excel_xsd Drilldown into PTFormula in schema excel_xsd Drilldown into PTSource in schema excel_xsd Drilldown into PTLineItems in schema excel_xsd Drilldown into CalculatedMember in schema excel_xsd Drilldown into CubeField in schema excel_xsd Drilldown into PivotField in schema excel_xsd Drilldown into DefaultVersion in schema excel_xsd Drilldown into VersionRefreshableMin in schema excel_xsd Drilldown into VersionLastUpdate in schema excel_xsd Drilldown into VersionUpdateableMin in schema excel_xsd Drilldown into PivotAxis in schema excel_xsd Drilldown into FieldListLeft in schema excel_xsd Drilldown into FieldListRight in schema excel_xsd Drilldown into FieldListBottom in schema excel_xsd Drilldown into FieldListTop in schema excel_xsd Drilldown into CacheDetails in schema excel_xsd Drilldown into ConnectionString in schema excel_xsd Drilldown into MemberExpand in schema excel_xsd Drilldown into MaxWidth in schema excel_xsd Drilldown into MaxHeight in schema excel_xsd Drilldown into Width in schema excel_xsd Drilldown into Height in schema excel_xsd Drilldown into NoAutoFit in schema excel_xsd Drilldown into DisplayFieldList in schema excel_xsd Drilldown into DataAxisEmpty in schema excel_xsd Drilldown into DataMember in schema excel_xsd Drilldown into PLTotal in schema excel_xsd Drilldown into PLPivotField in schema excel_xsd Drilldown into Location in schema excel_xsd Drilldown into VisualTotals in schema excel_xsd Drilldown into NoViewCalculatedMembers in schema excel_xsd Drilldown into HideDropDowns in schema excel_xsd Drilldown into ShowCellBackgroundFromOLAP in schema excel_xsd Drilldown into HideTotalsAnnotation in schema excel_xsd Drilldown into VacatedStyle in schema excel_xsd Drilldown into Tag in schema excel_xsd Drilldown into TableStyle in schema excel_xsd Drilldown into SmallGrid in schema excel_xsd Drilldown into ShowPageMultipleItemLabel in schema excel_xsd Drilldown into ImmediateItemsOnDrop in schema excel_xsd Drilldown into PLExport in schema excel_xsd Drilldown into PageFieldStyle in schema excel_xsd Drilldown into MergeLabels in schema excel_xsd Drilldown into PrintSetTitles in schema excel_xsd Drilldown into GrandTotalString in schema excel_xsd Drilldown into AutoFormatPattern in schema excel_xsd Drilldown into AutoFormatNumber in schema excel_xsd Drilldown into AutoFormatName in schema excel_xsd Drilldown into AutoFormatFont in schema excel_xsd Drilldown into AutoFormatBorder in schema excel_xsd Drilldown into AutoFormatAlignment in schema excel_xsd Drilldown into Selection in schema excel_xsd Drilldown into PivotView in schema excel_xsd Drilldown into NoPrintRepeatItems in schema excel_xsd Drilldown into NoDisplayNullString in schema excel_xsd Drilldown into NoColumnGrand in schema excel_xsd Drilldown into NoRowGrand in schema excel_xsd Drilldown into NoAutoFormatWidth in schema excel_xsd Drilldown into SubtotalHiddenPageItems in schema excel_xsd Drilldown into HasNoAutoFormat in schema excel_xsd Drilldown into NoPreserveFormatting in schema excel_xsd Drilldown into DisplayErrorString in schema excel_xsd Drilldown into DisableWizard in schema excel_xsd Drilldown into DisableFieldDialog in schema excel_xsd Drilldown into DisableDrillDown in schema excel_xsd Drilldown into PageFieldWrapCount in schema excel_xsd Drilldown into PageFieldOrder in schema excel_xsd Drilldown into NullString in schema excel_xsd Drilldown into ErrorString in schema excel_xsd Drilldown into QTSource in schema excel_xsd Drilldown into DataValueEditing in schema excel_xsd Drilldown into Name in schema excel_xsd Drilldown into PivotTableType in schema excel_xsdXSD Diagram of PivotTable in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:element name="PivotTable" type="PivotTableType">
    <xsd:annotation>
        <xsd:documentation>Contains information about a PivotTable view.</xsd:documentation>
    </xsd:annotation>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Name x:Name (1) (1)
DataValueEditing x:DataValueEditing 0 (1)
QTSource x:QTSource 0 (1)
ErrorString x:ErrorString 0 (1)
NullString x:NullString 0 (1)
PageFieldOrder x:PageFieldOrder 0 (1)
PageFieldWrapCount x:PageFieldWrapCount 0 (1)
DisableDrillDown x:DisableDrillDown 0 (1)
DisableFieldDialog x:DisableFieldDialog 0 (1)
DisableWizard x:DisableWizard 0 (1)
DisplayErrorString x:DisplayErrorString 0 (1)
NoPreserveFormatting x:NoPreserveFormatting 0 (1)
HasNoAutoFormat x:HasNoAutoFormat 0 (1)
SubtotalHiddenPageItems x:SubtotalHiddenPageItems 0 (1)
NoAutoFormatWidth x:NoAutoFormatWidth 0 (1)
NoRowGrand x:NoRowGrand 0 (1)
NoColumnGrand x:NoColumnGrand 0 (1)
NoDisplayNullString x:NoDisplayNullString 0 (1)
NoPrintRepeatItems x:NoPrintRepeatItems 0 (1)
PivotView x:PivotView 0 (1)
Selection x:Selection 0 (1)
AutoFormatAlignment x:AutoFormatAlignment 0 (1)
AutoFormatBorder x:AutoFormatBorder 0 (1)
AutoFormatFont x:AutoFormatFont 0 (1)
AutoFormatName x:AutoFormatName 0 (1)
AutoFormatNumber x:AutoFormatNumber 0 (1)
AutoFormatPattern x:AutoFormatPattern 0 (1)
GrandTotalString x:GrandTotalString 0 (1)
PrintSetTitles x:PrintSetTitles 0 (1)
MergeLabels x:MergeLabels 0 (1)
PageFieldStyle x:PageFieldStyle 0 (1)
PLExport x:PLExport 0 (1)
ImmediateItemsOnDrop x:ImmediateItemsOnDrop 0 (1)
ShowPageMultipleItemLabel x:ShowPageMultipleItemLabel 0 (1)
SmallGrid x:SmallGrid 0 (1)
TableStyle x:TableStyle 0 (1)
Tag x:Tag 0 (1)
VacatedStyle x:VacatedStyle 0 (1)
HideTotalsAnnotation x:HideTotalsAnnotation 0 (1)
ShowCellBackgroundFromOLAP x:ShowCellBackgroundFromOLAP 0 (1)
HideDropDowns x:HideDropDowns 0 (1)
NoViewCalculatedMembers x:NoViewCalculatedMembers 0 (1)
VisualTotals x:VisualTotals 0 (1)
Location x:Location (1) (1)
PLPivotField x:PLPivotField 0 unbounded
PLTotal x:PLTotal 0 unbounded
DataMember x:DataMember 0 (1)
DataAxisEmpty x:DataAxisEmpty 0 (1)
DisplayFieldList x:DisplayFieldList 0 (1)
NoAutoFit x:NoAutoFit 0 (1)
Height x:Height 0 (1)
Width x:Width 0 (1)
MaxHeight x:MaxHeight 0 (1)
MaxWidth x:MaxWidth 0 (1)
MemberExpand x:MemberExpand 0 (1)
ConnectionString x:ConnectionString 0 (1)
CacheDetails x:CacheDetails 0 (1)
FieldListTop x:FieldListTop 0 (1)
FieldListBottom x:FieldListBottom 0 (1)
FieldListRight x:FieldListRight 0 (1)
FieldListLeft x:FieldListLeft 0 (1)
PivotAxis x:PivotAxis 0 unbounded
VersionUpdateableMin x:VersionUpdateableMin 0 (1)
VersionLastUpdate x:VersionLastUpdate 0 (1)
VersionRefreshableMin x:VersionRefreshableMin 0 (1)
DefaultVersion x:DefaultVersion 0 (1)
PivotField x:PivotField (1) unbounded
CubeField x:CubeField 0 unbounded
CalculatedMember x:CalculatedMember 0 (1)
PTLineItems x:PTLineItems 0 unbounded
PTSource x:PTSource 0 (1)
PTFormula x:PTFormula 0 unbounded
PTFormat x:PTFormat 0 unbounded
Collapse Derivation Tree:
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0