Edit

Share via

workbookPivotTable resource type

  • Article

Namespace: microsoft.graph

Important

APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.

Represents an Excel PivotTable.

Methods

Method Return Type Description
Get workbookPivotTable Read the properties and relationships of a workbookPivotTable object.
Refresh a pivot table None Refresh the pivot table.
Refresh all pivot tables None Refresh all pivot tables within a specified worksheet. This action is available only on the pivot table collection.

Properties

Property Type Description
ID String The identifier for the pivot table. Read-only.
name String The name of the pivot table.

Relationships

Relationship Type Description
worksheet workbookWorksheet The worksheet that contains the current pivot table. Read-only.

JSON representation

The following JSON representation shows the resource type.

{
  "id": "String (identifier)",
  "name": "String"
}