3.1.1.8 PivotTable Entity

  • Article

The PivotTable entity represents a PivotTable in the spreadsheet. The protocol server will return a value as follows:

  • If a URL parameter with a key of "$format" and value of "html" is passed, or the ACCEPT HTTP header, as specified in [RFC2616] fits the content type: "text/html" then the protocol server will return an HTML fragment representing the requested PivotTable.

  • Accessing the PivotTable Entity as an entity as specified in [MS-ODATA] (or with a URL parameter with a key of "$format" and value of "atom") will result in a single Entity Type containing the complex type Range as defined in section 2.2.4.1.1 in a content element with a type attribute set to "application/xml", as specified in [MS-ODATA].

  • Accessing the PivotTable Entity with a URL parameter with a key of "$format" and value of "json" will result in a JSON text containing the complex type Range as defined in section 2.2.4.1.2.