This section contains examples of some of the most commonly used data structures in Excel Binary File Format files. The examples are meant to be a starting point for an implementer learning the file format. They are not meant to cover all records in the file format.
In the following sections, the schema definition might differ from the processing rules imposed by the application. The XSD in this specification provides a base description of the file format. The text that introduces the XSD specifies additional restrictions that reflect actual Microsoft product behavior. For example, the schema definition might allow for an element to be empty, null, or not present but the behavior of the application as specified restricts the same elements to being non-empty, not null, and present.
3.1 Slicer
This example shows a slicer attached to a native PivotTable and its associated slicer cache. The PivotTable has the "State" and "City" fields (1) added to the row (2) area and the "Population" field (1) added to the data area. The slicer is based on the "State" field (1), and is currently filtering on "Washington".
The following figure shows a possible implementation of the slicer discussed in this example.
Dostları ilə paylaş: |
