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.