workbookPivotTable resource type

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 workbookPivotTable Read properties and relationships of workbookPivotTable object.
Refresh None Refreshes the PivotTable.
Refreshall None Refresh all tables within given worksheet. This action is available only on the pivot table collection.

Properties

Property Type Description
ID String ID of the PivotTable. Read-only.
name String Name of the PivotTable.

Relationships

Relationship Type Description
worksheet workbookWorksheet The worksheet containing the current PivotTable. Read-only.

JSON representation

Here's a JSON representation of the resource.

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