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 | 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"
}