| title | workbookTableSort resource type |
|---|---|
| description | Manages sorting operations on Table objects. |
| author | lumine2008 |
| ms.localizationpriority | medium |
| ms.subservice | excel |
| doc_type | resourcePageType |
| toc.title | Table sort |
| ms.date | 08/01/2024 |
Namespace: microsoft.graph
Manages sorting operations on Table objects.
| Method | Return Type | Description |
|---|---|---|
| Get | workbookTableSort | Read the properties and relationships of the workbookTableSort object. |
| Apply sort | None | Perform a sort operation. |
| Clear sort | None | Clears the sorting that is currently on the table. While this doesn't modify the table's ordering, it clears the state of the header buttons. |
| Reapply sort | None | Reapplies the current sorting parameters to the table. |
| Property | Type | Description |
|---|---|---|
| fields | workbookSortField collection | The list of the current conditions last used to sort the table. Read-only. |
| matchCase | Boolean | Indicates whether the casing impacted the last sort of the table. Read-only. |
| method | string | The Chinese character ordering method last used to sort the table. The possible values are: PinYin, StrokeCount. Read-only. |
None.
The following JSON representation shows the resource type.
{
"matchCase": true,
"method": "string",
"fields": [{ "@odata.type": "microsoft.graph.workbookSortField" }]
}