XML - pivotTable part

The pivotTable part is organized into 11 sections.

  • Top-level attributes

  • Location information

  • Collection of Fields

  • Fields on the row axis

  • Items on the row axis (specific values)

  • Fields on the column axis

  • Items on the column axis (specific values)

  • Fields in the report filter area

  • Fields in the values area

  • Style information

  • This is what the shell of that structure looks like:

<pivotTableDefinition>
  <location/>
  <pivotFields/>
  <rowFields/>
  <rowItems/>
  <colFields/>
  <colItems/>
  <pageFields/>
  <dataFields/>
  </dataFields>
  <conditionalFormats/>
  <pivotTableStyleInfo/>
</pivotTableDefinition>

Each collection will now be addressed section by section.