Share via

3.1.1 Slicer Cache Part

  • Article

The following is an example slicer cache part, as specified in section 2.1.4.

 <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
 <slicerCacheDefinition xmlns="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main" name="Slicer_State" sourceName="State">
     <pivotTables>
         <pivotTable tabId="1" name="PivotTable1"/>
     </pivotTables>
     <data>
         <tabular pivotCacheId="5">
             <items count="2">
                 <i x="1"/>
                 <i x="0" s="1"/>
             </items>
         </tabular>
     </data>
 </slicerCacheDefinition>

The following table describes the slicerCacheDefinition element used in this example.

Attribute name

Value

Notes

name

Slicer_State

This is the name of the slicer cache.

sourceName

State

This is the name of the associated slicer, as specified in section 2.1.5.

The following table describes the pivotTable element used in this example.

Attribute name

Value

Notes

tabId

1

This indicates that the associated PivotTable, as specified in [ISO/IEC29500-1:2016] section 18.10, is located on the first sheet.

name

PivotTable1

This is the name of the associated PivotTable.

The following table describes the tabular element used in this example.

Attribute name

Value

Notes

pivotCacheId

5

This indicates that the identifier of the associated PivotTable PivotCache is "5".

The following table describes the items element used in this example.

Attribute name

Value

Notes

count

2

This indicates that there are two items in the slicer cache.

The following table describes the first i (item) element used in this example.

Attribute name

Value

Notes

x

1

This indicates that the first item in the slicer cache is the second item in the PivotTable PivotCache.

The following table describes the second i (item) element used in this example.

Attribute name

Value

Notes

x

0

This indicates that the second item in the slicer cache is the first item in the PivotTable PivotCache.

s

1

This indicates that this item is selected in the slicer.