Attributes on pivotTableDefinition

<pivotTableDefinition xmlns:sh="…" name="PivotTable2" cacheId="5"
  applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="0"
  applyPatternFormats="0" applyAlignmentFormats="0"
  applyWidthHeightFormats="1"
  dataCaption="Values" updatedVersion="3" minRefreshableVersion="3"
  showCalcMbrs="0" useAutoFormatting="1" colGrandTotals="0"
  itemPrintTitles="1"
  createdVersion="3" indent="0" outline="1" outlineData="1"
  multipleFieldFilters="0">

In the context of <pivotTableDefinition>:

  • @name indicates the name of the PivotTable.

  • @cacheId references by Id a particular pivotCache in the <pivotCaches> collection listed in workbook.xml.

  • @applyNumberFormats value of "1" means to apply legacy autoformat number format properties.

  • @applyBorderFormats value of "1" means to apply legacy autoformat border format properties.

  • @applyFontFormats value of "1" means to apply legacy autoformat Font format properties.

  • @applyPatternFormats value of "1" means to apply legacy autoformat pattern format properties.

  • @applyAlignmentFormats value of "1" means to apply legacy autoformat alignment format properties.

  • @applyWidthHeightFormats value of "1" means to apply legacy autoformat width and height format properties.

  • @dataCaption is the name of the values area header cell which can appear in the PivotTable when two or more fields are in the values area.

  • @updatedVersion is the Pivot version that last updated the PivotTable.

  • @minRefreshableVersion is the minimum Pivot version required to update this PivotTable's Pivot Cache.

  • @showCalcMbrs indicates whether calculated members should be shown in the PivotTable. Only applies to PivotTables based on OLAP sources.

  • @useAutoFormatting indicates whether autoformatting has been applied to the PivotTable.

  • @colGrandTotals indicates whether column grand totals are on for this PivotTable.

  • @rowGrandTotals defaults to "1" and therefore is not written.

  • @itemPrintTitles flag indicating whether PivotItem names should be repeated at the top of each printed page.

  • @createdVersion The Pivot version that created the cache.

  • @indent indentation increment for compact row axis, which means the Report Layout is set to Compact Form.

  • @outline flag indicating whether new fields should have their outline form flag set to "1".

  • @outlineData flag indicating whether the values field in the PivotTable should be displayed in outline form.

  • @multipleFieldFilters flag indicating whether each field of a pivot table can have multiple filters set on it.