| title | workbookPivotTable resource type |
|---|---|
| description | Represents an Excel PivotTable. |
| author | lumine2008 |
| ms.localizationpriority | medium |
| ms.subservice | excel |
| doc_type | resourcePageType |
| toc.title | Pivot table |
| ms.date | 07/17/2024 |
Namespace: microsoft.graph
[!INCLUDE beta-disclaimer]
Represents an Excel PivotTable.
| 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. |
| Property | Type | Description |
|---|---|---|
| ID | String | The identifier for the pivot table. Read-only. |
| name | String | The name of the pivot table. |
| Relationship | Type | Description |
|---|---|---|
| worksheet | workbookWorksheet | The worksheet that contains the current pivot table. Read-only. |
The following JSON representation shows the resource type.
{
"id": "String (identifier)",
"name": "String"
}