Files.ReadWrite

Allows the app to read, create, update and delete the signed-in user's files.

Graph Methods

Type: A = Application Permission, D = Delegate Permission

Ver	Type	Method
V1	D	/me/drive/items/{id}/workbook/worksheets/{id|name}/pivotTables/refreshAll
V1	D	DELETE /drive/bundles/{bundle-id}/children/{item-id}
V1	D	DELETE /drive/items/{bundle-id}
V1	D	DELETE /drives/{drive-id}/items/{item-id}
V1	D	DELETE /drives/{drive-id}/items/{item-id}/permissions/{perm-id}
V1	D	DELETE /groups/{group-id}/drive/items/{item-id}
V1	D	DELETE /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	DELETE /me/drive/following/{item-id}
V1	D	DELETE /me/drive/items/{id}/workbook/names/{name}
V1	D	DELETE /me/drive/items/{id}/workbook/tables/{id|name}
V1	D	DELETE /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}
V1	D	DELETE /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}
V1	D	DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}
V1	D	DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}
V1	D	DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/names/{name}
V1	D	DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}
V1	D	DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1	D	DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1	D	DELETE /me/drive/items/{item-id}
V1	D	DELETE /me/drive/items/{item-id}/permissions/{perm-id}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/names/{name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/tables/{id|name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/names/{name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1	D	DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1	D	DELETE /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	DELETE /sites/{siteId}/drive/items/{itemId}
V1	D	DELETE /users/{user-id}/drive/following/{item-id}
V1	D	DELETE /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	DELETE /users/{userId}/drive/items/{itemId}
V1	D	GET /drive/bundles
V1	D	GET /drive/bundles/{bundle-id}
V1	D	GET /drive/items/{bundle-id}
V1	D	GET /drive/items/{id}/workbook/comments/{id}/replies/{id}
V1	D	GET /drive/items/{item-id}/content?format={format}
V1	D	GET /drive/root:/{path and filename}:/content?format={format}
V1	D	GET /drives/{drive-id}/activities
V1	D	GET /drives/{drive-id}/items/{item-id}
V1	D	GET /drives/{drive-id}/items/{item-id}/activities
V1	D	GET /drives/{drive-id}/items/{item-id}/analytics
V1	D	GET /drives/{drive-id}/items/{item-id}/analytics/allTime
V1	D	GET /drives/{drive-id}/items/{item-id}/analytics/lastSevenDays
V1	D	GET /drives/{drive-id}/items/{item-id}/children
V1	D	GET /drives/{drive-id}/items/{item-id}/content
V1	D	GET /drives/{drive-id}/items/{item-id}/getActivitiesByInterval(startDateTime='2017-01-01',endDateTime='2017-01-10',interval='day')
V1	D	GET /drives/{drive-id}/items/{item-id}/permissions
V1	D	GET /drives/{drive-id}/items/{item-id}/permissions/{perm-id}
V1	D	GET /drives/{drive-id}/items/{item-id}/thumbnails
V1	D	GET /drives/{drive-id}/items/{item-id}/versions
V1	D	GET /drives/{drive-id}/items/{item-id}/versions/{version-id}
V1	D	GET /drives/{drive-id}/items/{item-id}/versions/{version-id}/content
V1	D	GET /drives/{drive-id}/root:/{item-path}
V1	D	GET /drives/{drive-id}/root/delta
V1	D	GET /drives/{drive-id}/root/search(q='{search-text}')
V1	D	GET /drives/{driveId}/list/subscriptions/socketIo
V1	D	GET /drives/{driveId}/root/subscriptions/socketIo
V1	D	GET /groups/{group-id}/drive/items/{item-id}
V1	D	GET /groups/{group-id}/drive/items/{item-id}/children
V1	D	GET /groups/{group-id}/drive/items/{item-id}/content
V1	D	GET /groups/{group-id}/drive/items/{item-id}/permissions
V1	D	GET /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	GET /groups/{group-id}/drive/items/{item-id}/thumbnails
V1	D	GET /groups/{group-id}/drive/items/{item-id}/versions
V1	D	GET /groups/{group-id}/drive/items/{item-id}/versions/{version-id}
V1	D	GET /groups/{group-id}/drive/items/{item-id}/versions/{version-id}/content
V1	D	GET /groups/{group-id}/drive/root:/{item-path}
V1	D	GET /groups/{group-id}/drive/root/search(q='{search-text}')
V1	D	GET /groups/{groupId}/drive/root/delta
V1	D	GET /groups/{groupId}/drive/root/subscriptions/socketIo
V1	D	GET /groups/{groupId}/drives
V1	D	GET /me/drive
V1	D	GET /me/drive/following
V1	D	GET /me/drive/items/{id}/workbook/application
V1	D	GET /me/drive/items/{id}/workbook/comments
V1	D	GET /me/drive/items/{id}/workbook/comments/{id}
V1	D	GET /me/drive/items/{id}/workbook/comments/{id}/replies
V1	D	GET /me/drive/items/{id}/workbook/comments/{id}/replies/{id}
V1	D	GET /me/drive/items/{id}/workbook/names
V1	D	GET /me/drive/items/{id}/workbook/names/{name}
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/Range
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/boundingRect
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/BoundingRect
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/cell
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/Cell
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/column
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/Column
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/entireColumn
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/EntireColumn
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/entireRow
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/EntireRow
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format/borders
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format/borders()
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format/borders/{sideIndex}
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format/fill
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format/font
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/format/protection
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/intersection
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/Intersection
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/lastCell
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/LastCell
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/lastColumn
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/LastColumn
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/lastRow
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/LastRow
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/offsetRange
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/OffsetRange
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/usedRange
V1	D	GET /me/drive/items/{id}/workbook/names/{name}/range/UsedRange
V1	D	GET /me/drive/items/{id}/workbook/operations/{operation-id}
V1	D	GET /me/drive/items/{id}/workbook/tableRowOperationResult(key={operation-id})
V1	D	GET /me/drive/items/{id}/workbook/tables
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/dataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/DataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/headerRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/Range
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/boundingRect
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/BoundingRect
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/cell
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Cell
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/column
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Column
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/entireColumn
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/EntireColumn
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/entireRow
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/EntireRow
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/intersection
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Intersection
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/lastCell
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/LastCell
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/lastColumn
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/LastColumn
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/lastRow
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/LastRow
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/offsetRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/OffsetRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/usedRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/UsedRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/totalRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/TotalRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/dataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/DataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/headerRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/HeaderRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/range
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/Range
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/rows
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}/Range
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/itemAt(index={index})/range
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/sort
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/sort/fields/icon
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/totalRowRange
V1	D	GET /me/drive/items/{id}/workbook/tables/{id|name}/TotalRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables/{id}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView/itemAt(index={n})
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView/range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView/rows
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range/columnsAfter(count=n)
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range/columnsBefore(count=n)
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range/rowsAbove(count=n)
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id}/range/rowsBelow(count=n)
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/cell(row={row},column={column})
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/Cell(row={row},column={column})
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/Image(width=0,height=0,fittingMode='fit')
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480,fittingMode='fit')
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480)
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image(width=640)
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/{point-id}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/{undefined}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/names
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/protection
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/Range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range( )/format/protection
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/boundingRect
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/BoundingRect
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/cell
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/Cell
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/column
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/Column
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/entireColumn
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/EntireColumn
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/EntireRow
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders()
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders/{sideIndex}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/fill
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/font
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/intersection
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/Intersection
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/lastCell
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/LastCell
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/lastColumn
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/LastColumn
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/lastRow
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/LastRow
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/offsetRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/OffsetRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/usedRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/UsedRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' '/entireRow
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/dataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/DataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/headerRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/Range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/totalRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/TotalRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/dataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/DataBodyRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/headerRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/HeaderRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/Range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}/Range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt(index={index})range
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/totalRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/TotalRowRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/usedRange
V1	D	GET /me/drive/items/{id}/workbook/worksheets/{id|name}/UsedRange
V1	D	GET /me/drive/items/{item-id}
V1	D	GET /me/drive/items/{item-id}/children
V1	D	GET /me/drive/items/{item-id}/content
V1	D	GET /me/drive/items/{item-id}/permissions
V1	D	GET /me/drive/items/{item-id}/permissions/{perm-id}
V1	D	GET /me/drive/items/{item-id}/thumbnails
V1	D	GET /me/drive/items/{item-id}/versions
V1	D	GET /me/drive/items/{item-id}/versions/{version-id}
V1	D	GET /me/drive/items/{item-id}/versions/{version-id}/content
V1	D	GET /me/drive/recent
V1	D	GET /me/drive/root:/{item-path}
V1	D	GET /me/drive/root:/{item-path}:/content
V1	D	GET /me/drive/root:/{item-path}:/workbook/application
V1	D	GET /me/drive/root:/{item-path}:/workbook/comments
V1	D	GET /me/drive/root:/{item-path}:/workbook/comments/{id}/replies
V1	D	GET /me/drive/root:/{item-path}:/workbook/comments/{id}/replies/{id}
V1	D	GET /me/drive/root:/{item-path}:/workbook/names
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/boundingRect
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/BoundingRect
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/cell
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/Cell
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/column
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/Column
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/entireColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/EntireColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/entireRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/EntireRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders()
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/{sideIndex}
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/fill
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/protection
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/intersection
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/Intersection
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/lastCell
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/LastCell
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/lastColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/LastColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/lastRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/LastRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/offsetRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/OffsetRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/usedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/UsedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tableRowOperationResult(key={operation-id})
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/dataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/DataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/headerRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/boundingRect
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/BoundingRect
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/cell
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Cell
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/column
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Column
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/entireColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/EntireColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/entireRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/EntireRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/intersection
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Intersection
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/lastCell
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/LastCell
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/lastColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/LastColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/lastRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/LastRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/offsetRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/OffsetRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/usedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/UsedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/totalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/TotalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/dataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/DataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/headerRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/HeaderRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/itemAt(index={index})/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/fields/icon
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/totalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/TotalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables/{id}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView/itemAt(index={n})
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView/rows
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/columnsAfter(count=n)
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/columnsBefore(count=n)
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/rowsAbove(count=n)
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/rowsBelow(count=n)
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/cell(row={row},column={column})
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/Cell(row={row},column={column})
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/Image(width=0,height=0,fittingMode='fit')
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480,fittingMode='fit')
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480)
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image(width=640)
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/{point-id}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/{undefined}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/names
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/protection
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range( )/format/protection
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/boundingRect
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/BoundingRect
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/cell
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/Cell
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/column
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/Column
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/entireColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/EntireColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/EntireRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders()
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders/{sideIndex}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/fill
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/font
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/intersection
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/Intersection
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/lastCell
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/LastCell
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/lastColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/LastColumn
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/lastRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/LastRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/offsetRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/OffsetRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/usedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/UsedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' '/entireRow
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/dataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/DataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/headerRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/totalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/TotalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/dataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/DataBodyRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/headerRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/HeaderRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}/Range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt(index={index})/range
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/totalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/TotalRowRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/usedRange
V1	D	GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/UsedRange
V1	D	GET /me/drive/root:/{path}:/permissions
V1	D	GET /me/drive/root/delta
V1	D	GET /me/drive/root/search(q='{search-text}')
V1	D	GET /me/drive/root/subscriptions/socketIo
V1	D	GET /me/drive/special/{name}
V1	D	GET /shares/{shareIdOrEncodedSharingUrl}
V1	D	GET /shares/{shareIdOrEncodedSharingUrl}/driveItem/content
V1	D	GET /sites/{site-id}/analytics
V1	D	GET /sites/{site-id}/analytics/allTime
V1	D	GET /sites/{site-id}/analytics/lastSevenDays
V1	D	GET /sites/{site-id}/drive/items/{item-id}
V1	D	GET /sites/{site-id}/drive/items/{item-id}/children
V1	D	GET /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	GET /sites/{site-id}/drive/items/{item-id}/thumbnails
V1	D	GET /sites/{site-id}/drive/items/{item-id}/versions
V1	D	GET /sites/{site-id}/drive/items/{item-id}/versions/{version-id}
V1	D	GET /sites/{site-id}/drive/items/{item-id}/versions/{version-id}/content
V1	D	GET /sites/{site-id}/drive/root:/{item-path}
V1	D	GET /sites/{site-id}/drive/root/search(q='{search-text}')
V1	D	GET /sites/{site-id}/getActivitiesByInterval(startDateTime='2016-01-01',endDateTime='2017-05-20',interval='month')
V1	D	GET /sites/{site-id}/getActivitiesByInterval(startDateTime='2016',endDateTime='2017',interval='month')
V1	D	GET /sites/{site-id}/lists/{list-id}/activities
V1	D	GET /sites/{site-id}/lists/{list-id}/items/{item-id}/activities
V1	D	GET /sites/{site-id}/lists/{list-id}/items/{item-id}/analytics
V1	D	GET /sites/{site-id}/lists/{list-id}/items/{item-id}/analytics/allTime
V1	D	GET /sites/{site-id}/lists/{list-id}/items/{item-id}/analytics/lastSevenDays
V1	D	GET /sites/{site-id}/lists/{list-id}/items/{item-id}/driveItem
V1	D	GET /sites/{site-id}/lists/{list-id}/items/{item-id}/getActivitiesByInterval(startDateTime='2017-05-01',endDateTime='2017-05-20',interval='week')
V1	D	GET /sites/{siteId}/drive/items/{item-id}/content
V1	D	GET /sites/{siteId}/drive/items/{itemId}
V1	D	GET /sites/{siteId}/drive/items/{itemId}/permissions
V1	D	GET /sites/{siteId}/drive/root:/{item-path}
V1	D	GET /sites/{siteId}/drive/root/delta
V1	D	GET /sites/{siteId}/lists/{listId}/drive/root/subscriptions/socketIo
V1	D	GET /teams/{teamId}/channels/{channelId}/filesFolder
V1	D	GET /users/{user-id}/drive/items/{item-id}
V1	D	GET /users/{user-id}/drive/items/{item-id}/children
V1	D	GET /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	GET /users/{user-id}/drive/items/{item-id}/thumbnails
V1	D	GET /users/{user-id}/drive/items/{item-id}/versions
V1	D	GET /users/{user-id}/drive/items/{item-id}/versions/{version-id}
V1	D	GET /users/{user-id}/drive/items/{item-id}/versions/{version-id}/content
V1	D	GET /users/{user-id}/drive/root:/{item-path}
V1	D	GET /users/{user-id}/drive/root/search(q='{search-text}')
V1	D	GET /users/{userId}/drive/items/{item-id}/content
V1	D	GET /users/{userId}/drive/items/{itemId}
V1	D	GET /users/{userId}/drive/items/{itemId}/permissions
V1	D	GET /users/{userId}/drive/root:/{item-path}
V1	D	GET /users/{userId}/drive/root/delta
V1	D	GET https://graph.microsoft.com/v1.0/groups/02bd9fd6-8f93-4758-87c3-1fb73740a315/drives
V1	D	PATCH /drive/items/{bundle-id}
V1	D	PATCH /drives/{drive-id}/items/{item-id}
V1	D	PATCH /drives/{drive-id}/items/{item-id}/permissions/{perm-id}
V1	D	PATCH /groups/{group-id}/drive/items/{item-id}
V1	D	PATCH /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range/format
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/borders()
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/borders/{sideIndex}
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/fill
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/protection
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}
V1	D	PATCH /me/drive/items/{id}/workbook/tables/{id|name}/sort/fields/icon
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range( )/format/protection
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders()
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders/{sideIndex}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/fill
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/font
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1	D	PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1	D	PATCH /me/drive/items/{item-id}
V1	D	PATCH /me/drive/items/{item-id}/permissions/{perm-id}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders()
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/{sideIndex}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/fill
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/protection
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/fields/icon
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range( )/format/protection
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders()
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders/{sideIndex}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/fill
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/font
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1	D	PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1	D	PATCH /sites/{site-id}/drive/items/{item-id}
V1	D	PATCH /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	PATCH /users/{user-id}/drive/items/{item-id}
V1	D	PATCH /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}
V1	D	POST /drive/bundles
V1	D	POST /drive/bundles/{bundle-id}/children
V1	D	POST /drives/{drive-id}/items/{item-id}/follow
V1	D	POST /drives/{drive-id}/items/{item-id}/invite
V1	D	POST /drives/{drive-id}/items/{item-id}/permissions/{perm-id}/revokeGrants
V1	D	POST /drives/{drive-id}/items/{parent-item-id}/children
V1	D	POST /drives/{driveId}/items/{itemId}/checkin
V1	D	POST /drives/{driveId}/items/{itemId}/checkout
V1	D	POST /drives/{driveId}/items/{itemId}/copy
V1	D	POST /drives/{driveId}/items/{itemId}/createLink
V1	D	POST /drives/{driveId}/items/{itemId}/createUploadSession
V1	D	POST /drives/{driveId}/items/{itemId}/preview
V1	D	POST /drives/{driveId}/items/{itemId}/versions/{version-id}/restoreVersion
V1	D	POST /groups/{group-id}/drive/items/{item-id}/follow
V1	D	POST /groups/{group-id}/drive/items/{item-id}/invite
V1	D	POST /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1	D	POST /groups/{group-id}/drive/items/{parent-item-id}/children
V1	D	POST /groups/{groupId}/drive/items/{itemId}/checkin
V1	D	POST /groups/{groupId}/drive/items/{itemId}/checkout
V1	D	POST /groups/{groupId}/drive/items/{itemId}/copy
V1	D	POST /groups/{groupId}/drive/items/{itemId}/createLink
V1	D	POST /groups/{groupId}/drive/items/{itemId}/createUploadSession
V1	D	POST /groups/{groupId}/drive/items/{itemId}/preview
V1	D	POST /groups/{groupId}/drive/items/{itemId}/versions/{version-id}/restoreVersion
V1	D	POST /me/drive/items/{id}/workbook/application/calculate
V1	D	POST /me/drive/items/{id}/workbook/closeSession
V1	D	POST /me/drive/items/{id}/workbook/comments/{id}/replies
V1	D	POST /me/drive/items/{id}/workbook/createSession
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/clear
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/delete
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/format/autofitColumns
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/format/autofitRows
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/format/borders
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/format/borders/itemAt
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/format/borders/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/format/fill/clear
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/insert
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/merge
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/row
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/Row
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/sort/apply
V1	D	POST /me/drive/items/{id}/workbook/names/{name}/range/unmerge
V1	D	POST /me/drive/items/{id}/workbook/names/add
V1	D	POST /me/drive/items/{id}/workbook/refreshSession
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/clearFilters
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/filter/apply
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/filter/clear
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/clear
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/delete
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitColumns
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitRows
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/itemAt
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/fill/clear
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/insert
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/merge
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/row
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Row
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/sort/apply
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/unmerge
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/add
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/itemAt
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/convertToRange
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/reapplyFilters
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/rows
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/rows/add
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/rows/itemAt
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/rows/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/sort/apply
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/sort/clear
V1	D	POST /me/drive/items/{id}/workbook/tables/{id|name}/sort/reapply
V1	D	POST /me/drive/items/{id}/workbook/tables/{table-id}/add
V1	D	POST /me/drive/items/{id}/workbook/tables/$/add
V1	D	POST /me/drive/items/{id}/workbook/tables/add
V1	D	POST /me/drive/items/{id}/workbook/worksheets/
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables/{id}/refresh
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables/refreshAll
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id}/range/resizedRange(deltaRows={n}, deltaColumns={n})
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/format/fill/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/format/fill/setSolidColor
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/setSolidColor
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/itemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/itemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/setData
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/setPosition
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/setSolidColor
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/add
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/itemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/names/add
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/pivotTables/refreshAll
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/protection/protect
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/protection/unprotect
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/delete
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/autofitColumns
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/autofitRows
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders/itemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/borders/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/format/fill/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/insert
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/merge
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/row
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/Row
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/sort/apply
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address=' ')/unmerge
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/clearFilters
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/apply
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/add
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/itemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/convertToRange
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/reapplyFilters
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/add
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/ItemAt
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/apply
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/clear
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/reapply
V1	D	POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/add
V1	D	POST /me/drive/items/{id}/workbook/worksheets/add
V1	D	POST /me/drive/items/{item-id}/checkin
V1	D	POST /me/drive/items/{item-id}/checkout
V1	D	POST /me/drive/items/{item-id}/copy
V1	D	POST /me/drive/items/{item-id}/follow
V1	D	POST /me/drive/items/{item-id}/invite
V1	D	POST /me/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1	D	POST /me/drive/items/{item-id}/unfollow
V1	D	POST /me/drive/items/{item-id}/versions/{version-id}/restoreVersion
V1	D	POST /me/drive/items/{itemId}:/{fileName}:/createUploadSession
V1	D	POST /me/drive/items/{itemId}/createLink
V1	D	POST /me/drive/items/{itemId}/createUploadSession
V1	D	POST /me/drive/items/{itemId}/preview
V1	D	POST /me/drive/items/{parent-item-id}/children
V1	D	POST /me/drive/root:/{item-path}:/workbook/application/calculate
V1	D	POST /me/drive/root:/{item-path}:/workbook/closeSession
V1	D	POST /me/drive/root:/{item-path}:/workbook/comments/{id}/replies
V1	D	POST /me/drive/root:/{item-path}:/workbook/createSession
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/delete
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/autofitColumns
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/autofitRows
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/fill/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/insert
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/merge
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/row
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/Row
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/sort/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/unmerge
V1	D	POST /me/drive/root:/{item-path}:/workbook/names/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/refreshSession
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/clearFilters
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/filter/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/filter/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/delete
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitColumns
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitRows
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/fill/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/insert
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/merge
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/row
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Row
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/sort/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/unmerge
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/convertToRange
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/reapplyFilters
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/reapply
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/{table-id}/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/$/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/tables/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables/{id}/refresh
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables/refreshAll
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/resizedRange(deltaRows={n}, deltaColumns={n})
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/format/fill/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/format/fill/setSolidColor
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/setSolidColor
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/setData
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/setPosition
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/setSolidColor
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/names/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/pivotTables/refreshAll
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/protection/protect
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/protection/unprotect
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/delete
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/autofitColumns
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/autofitRows
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/borders/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/format/fill/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/insert
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/merge
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/row
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/Row
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/sort/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address=' ')/unmerge
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/clearFilters
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/convertToRange
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/reapplyFilters
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/ItemAt
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/apply
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/clear
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/reapply
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/add
V1	D	POST /me/drive/root:/{item-path}:/workbook/worksheets/add
V1	D	POST /shares/{encoded-sharing-url}/permission/grant
V1	D	POST /shares/{shareId}/driveItem/preview
V1	D	POST /sites/{site-id}/drive/items/{item-id}/follow
V1	D	POST /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1	D	POST /sites/{site-id}/drive/items/{parent-item-id}/children
V1	D	POST /sites/{site-id}/lists/{list-id}/items/{listItem-id}/driveItem/permissions/{perm-id}/revokeGrants
V1	D	POST /sites/{siteId}/drive/items/{itemId}/checkin
V1	D	POST /sites/{siteId}/drive/items/{itemId}/checkout
V1	D	POST /sites/{siteId}/drive/items/{itemId}/copy
V1	D	POST /sites/{siteId}/drive/items/{itemId}/createLink
V1	D	POST /sites/{siteId}/drive/items/{itemId}/createUploadSession
V1	D	POST /sites/{siteId}/drive/items/{itemId}/invite
V1	D	POST /sites/{siteId}/drive/items/{itemId}/preview
V1	D	POST /sites/{siteId}/drive/items/{itemId}/versions/{version-id}/restoreVersion
V1	D	POST /sites/{siteId}/lists/{listId}/items/{itemId}/createLink
V1	D	POST /sites/{siteId}/pages/{pageId}/publish
V1	D	POST /users/{user-id}/drive/items/{item-id}/follow
V1	D	POST /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1	D	POST /users/{user-id}/drive/items/{item-id}/unfollow
V1	D	POST /users/{user-id}/drive/items/{parent-item-id}/children
V1	D	POST /users/{userId}/drive/items/{itemId}/checkin
V1	D	POST /users/{userId}/drive/items/{itemId}/checkout
V1	D	POST /users/{userId}/drive/items/{itemId}/copy
V1	D	POST /users/{userId}/drive/items/{itemId}/createLink
V1	D	POST /users/{userId}/drive/items/{itemId}/createUploadSession
V1	D	POST /users/{userId}/drive/items/{itemId}/invite
V1	D	POST /users/{userId}/drive/items/{itemId}/preview
V1	D	POST /users/{userId}/drive/items/{itemId}/versions/{version-id}/restoreVersion
V1	D	PUT /drives/{drive-id}/items/{item-id}/content
V1	D	PUT /groups/{group-id}/drive/items/{item-id}/content
V1	D	PUT /me/drive/items/{item-id}/content
V1	D	PUT /sites/{site-id}/drive/items/{item-id}/content
V1	D	PUT /users/{user-id}/drive/items/{item-id}/content
V1	D	workbook-session-id: {session-id}

Delegate Permission

Id	5c28f0bf-8a70-41f1-8ab2-9032436ddb65
Consent Type	User
Display String	Have full access to user files
Description	Allows the app to read, create, update and delete the signed-in user's files.

Resources

bundle

Chart

Property	Type	Description
height	double	Represents the height, in points, of the chart object.
id	string	Gets a chart based on its position in the collection. Read-only.
left	double	The distance, in points, from the left side of the chart to the worksheet origin.
name	string	Represents the name of a chart object.
top	double	Represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
width	double	Represents the width, in points, of the chart object.

ChartAxis

Property	Type	Description
id	string	Unique identifier. Read-only.
majorUnit	Json	Represents the interval between two major tick marks. Can be set to a numeric value or an empty string. The returned value is always a number.
maximum	Json	Represents the maximum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minimum	Json	Represents the minimum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minorUnit	Json	Represents the interval between two minor tick marks. "Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.

ChartAxisTitle

Property	Type	Description
text	string	Represents the axis title.
visible	boolean	A boolean that specifies the visibility of an axis title.

ChartDataLabels

Property	Type	Description
position	string	DataLabelPosition value that represents the position of the data label. The possible values are: None, Center, InsideEnd, InsideBase, OutsideEnd, Left, Right, Top, Bottom, BestFit, Callout.
separator	string	String representing the separator used for the data labels on a chart.
showBubbleSize	boolean	Boolean value representing if the data label bubble size is visible or not.
showCategoryName	boolean	Boolean value representing if the data label category name is visible or not.
showLegendKey	boolean	Boolean value representing if the data label legend key is visible or not.
showPercentage	boolean	Boolean value representing if the data label percentage is visible or not.
showSeriesName	boolean	Boolean value representing if the data label series name is visible or not.
showValue	boolean	Boolean value representing if the data label value is visible or not.

ChartFont

Property	Type	Description
bold	boolean	Represents the bold status of font.
color	string	HTML color code representation of the text color. E.g. #FF0000 represents Red.
italic	boolean	Represents the italic status of the font.
name	string	Font name (e.g. "Calibri")
size	double	Size of the font (e.g. 11)
underline	string	Type of underline applied to the font. The possible values are: None, Single.

ChartGridlines

Property	Type	Description
visible	boolean	Boolean value representing if the axis gridlines are visible or not.

ChartLegend

Property	Type	Description
overlay	boolean	Boolean value for whether the chart legend should overlap with the main body of the chart.
position	string	Represents the position of the legend on the chart. The possible values are: Top, Bottom, Left, Right, Corner, Custom.
visible	boolean	A boolean value the represents the visibility of a ChartLegend object.

ChartLineFormat

Property	Type	Description
color	string	HTML color code representing the color of lines in the chart.

ChartPoint

Property	Type	Description
id	string	unique identifier
value	Json	Returns the value of a chart point. Read-only.

ChartSeries

Property	Type	Description
name	string	Represents the name of a series in a chart.

ChartTitle

Property	Type	Description
overlay	boolean	Boolean value representing if the chart title will overlay the chart or not.
text	string	Represents the title text of a chart.
visible	boolean	A boolean value the represents the visibility of a chart title object.

deleted

Property	Type	Description
state	String	Represents the state of the deleted item.

drive

Property	Type	Description
createdBy	[identitySet][]	Identity of the user, device, or application which created the item. Read-only.
createdDateTime	dateTimeOffset	Date and time of item creation. Read-only.
description	String	Provide a user-visible description of the drive. Read-write.
driveType	String	Describes the type of drive represented by this resource. OneDrive personal drives will return personal. OneDrive for Business will return business. SharePoint document libraries will return documentLibrary. Read-only.
id	String	The unique identifier of the drive. Read-only.
lastModifiedBy	[identitySet][]	Identity of the user, device, and application which last modified the item. Read-only.
lastModifiedDateTime	dateTimeOffset	Date and time the item was last modified. Read-only.
name	string	The name of the item. Read-write.
owner	identitySet	Optional. The user account that owns the drive. Read-only.
quota	quota	Optional. Information about the drive's storage space quota. Read-only.
sharepointIds	[sharepointIds][]	Returns identifiers useful for SharePoint REST compatibility. Read-only. This property is not returned by default and must be selected using the $select query parameter.
system	[systemFacet][]	If present, indicates that this is a system-managed drive. Read-only.
webUrl	string (url)	URL that displays the resource in the browser. Read-only.

driveItem

Property	Type	Description
audio	[audio][]	Audio metadata, if the item is an audio file. Read-only. Read-only. Only on OneDrive Personal.
bundle	[bundle][]	Bundle metadata, if the item is a bundle. Read-only.
content	Stream	The content stream, if the item represents a file.
createdBy	[identitySet][]	Identity of the user, device, and application which created the item. Read-only.
createdDateTime	DateTimeOffset	Date and time of item creation. Read-only.
cTag	String	An eTag for the content of the item. This eTag is not changed if only the metadata is changed. Note This property is not returned if the item is a folder. Read-only.
deleted	[deleted][]	Information about the deleted state of the item. Read-only.
description	String	Provides a user-visible description of the item. Read-write. Only on OneDrive Personal.
eTag	String	eTag for the entire item (metadata + content). Read-only.
file	[file][]	File metadata, if the item is a file. Read-only.
fileSystemInfo	[fileSystemInfo][]	File system information on client. Read-write.
folder	[folder][]	Folder metadata, if the item is a folder. Read-only.
id	String	The unique identifier of the item within the Drive. Read-only.
image	[image][]	Image metadata, if the item is an image. Read-only.
lastModifiedBy	[identitySet][]	Identity of the user, device, and application which last modified the item. Read-only.
lastModifiedDateTime	DateTimeOffset	Date and time the item was last modified. Read-only.
location	[geoCoordinates][]	Location metadata, if the item has location data. Read-only.
malware	[malware][]	Malware metadata, if the item was detected to contain malware. Read-only.
name	String	The name of the item (filename and extension). Read-write.
package	[package][]	If present, indicates that this item is a package instead of a folder or file. Packages are treated like files in some contexts and folders in others. Read-only.
parentReference	[itemReference][]	Parent information, if the item has a parent. Read-write.
pendingOperations	[pendingOperations][]	If present, indicates that one or more operations that might affect the state of the driveItem are pending completion. Read-only.
photo	[photo][]	Photo metadata, if the item is a photo. Read-only.
publication	[publicationFacet][]	Provides information about the published or checked-out state of an item, in locations that support such actions. This property is not returned by default. Read-only.
remoteItem	[remoteItem][]	Remote item data, if the item is shared from a drive other than the one being accessed. Read-only.
root	[root][]	If this property is non-null, it indicates that the driveItem is the top-most driveItem in the drive.
searchResult	[searchResult][]	Search metadata, if the item is from a search result. Read-only.
shared	[shared][]	Indicates that the item has been shared with others and provides information about the shared state of the item. Read-only.
sharepointIds	[sharepointIds][]	Returns identifiers useful for SharePoint REST compatibility. Read-only.
size	Int64	Size of the item in bytes. Read-only.
specialFolder	[specialFolder][]	If the current item is also available as a special folder, this facet is returned. Read-only.
video	[video][]	Video metadata, if the item is a video. Read-only.
webDavUrl	String	WebDAV compatible URL for the item.
webUrl	String	URL that displays the resource in the browser. Read-only.

driverecipient

formatProtection

Property	Type	Description
formulaHidden	boolean	Indicates if Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have uniform formula hidden setting.
locked	boolean	Indicates if Excel locks the cells in the object. A null value indicates that the entire range doesn't have uniform lock setting.

Icon

Property	Type	Description
index	int	Represents the index of the icon in the given set.
set	string	Represents the set that the icon is part of. The possible values are: Invalid, ThreeArrows, ThreeArrowsGray, ThreeFlags, ThreeTrafficLights1, ThreeTrafficLights2, ThreeSigns, ThreeSymbols, ThreeSymbols2, FourArrows, FourArrowsGray, FourRedToBlack, FourRating, FourTrafficLights, FiveArrows, FiveArrowsGray, FiveRating, FiveQuarters, ThreeStars, ThreeTriangles, FiveBoxes.

itemActivity

Property	Type	Description
access	[accessAction][]	An item was accessed.
activityDateTime	DateTimeOffset	Details about when the activity took place. Read-only.
actor	[identitySet][]	Identity of who performed the action. Read-only.
id	string	The unique identifier of the activity. Read-only.

itemActivityStat

Property	Type	Description
access	[itemActionStat][]	Statistics about the access actions in this interval. Read-only.
create	[itemActionStat][]	Statistics about the create actions in this interval. Read-only.
delete	[itemActionStat][]	Statistics about the delete actions in this interval. Read-only.
edit	[itemActionStat][]	Statistics about the edit actions in this interval. Read-only.
endDateTime	DateTimeOffset	When the interval ends. Read-only.
incompleteData	[incompleteData][]	Indicates that the statistics in this interval are based on incomplete data. Read-only.
isTrending	Boolean	Indicates whether the item is "trending." Read-only.
move	[itemActionStat][]	Statistics about the move actions in this interval. Read-only.
startDateTime	DateTimeOffset	When the interval starts. Read-only.

itemAnalytics

Property	Type	Description
allTime	[itemActivityStat][]	Analytics over the item's lifespan.
lastSevenDays	[itemActivityStat][]	Analytics for the last seven days.

ItemReference

Property	Type	Description
driveId	String	Unique identifier of the drive instance that contains the item. Read-only.
driveType	String	Identifies the type of drive. See [drive][] resource for values.
id	String	Unique identifier of the item in the drive. Read-only.
name	String	The name of the item being referenced. Read-only.
path	String	Path that can be used to navigate to the item. Read-only.
shareId	String	A unique identifier for a shared resource that can be accessed via the [Shares][] API.
sharepointIds	[sharepointIds][]	Returns identifiers useful for SharePoint REST compatibility. Read-only.
siteId	String	For OneDrive for Business and SharePoint, this property represents the ID of the site that contains the parent document library of the driveItem resource. The value is the same as the id property of that site][] resource. It is an [opaque string that consists of three identifiers of the site. For OneDrive, this property is not populated.

json

list

listitem

Property	Type	Description
contentType	[contentTypeInfo][]	The content type of this list item

NamedItem

Property	Type	Description
comment	string	Represents the comment associated with this name.
name	string	The name of the object. Read-only.
scope	string	Indicates whether the name is scoped to the workbook or to a specific worksheet. Read-only.
type	string	Indicates what type of reference is associated with the name. The possible values are: String, Integer, Double, Boolean, Range. Read-only.
value	Json	Represents the formula that the name is defined to refer to. E.g. =Sheet14!$B$2:$H$12, =4.75, etc. Read-only.
visible	boolean	Specifies whether the object is visible or not.

Permission

Property	Type	Description
expirationDateTime	DateTimeOffset	A format of yyyy-MM-ddTHH:mm:ssZ of DateTimeOffset indicates the expiration time of the permission. DateTime.MinValue indicates there is no expiration set for this permission. Optional.
id	String	The unique identifier of the permission among all permissions on the item. Read-only.
hasPassword	Boolean	Indicates whether the password is set for this permission. This property only appears in the response. Optional. Read-only. For OneDrive Personal only..
grantedTo (deprecated)	IdentitySet	For user type permissions, the details of the users and applications for this permission. Read-only.
grantedToIdentities (deprecated)	Collection(IdentitySet)	For type permissions, the details of the users to whom permission was granted. Read-only.
grantedToIdentitiesV2	Collection([SharePointIdentitySet][])	For link type permissions, the details of the users to whom permission was granted. Read-only.
grantedToV2	[SharePointIdentitySet][]	For user type permissions, the details of the users and applications for this permission. Read-only.
inheritedFrom	ItemReference	Provides a reference to the ancestor of the current permission, if it is inherited from an ancestor. Read-only.
invitation	[SharingInvitation][]	Details of any associated sharing invitation for this permission. Read-only.
link	[SharingLink][]	Provides the link details of the current permission, if it is a link type permissions. Read-only.
roles	Collection of String	The type of permission, for example, read. See below for the full list of roles. Read-only.
shareId	String	A unique token that can be used to access this shared item via the shares API. Read-only.

Range

Property	Type	Description
address	string	Represents the range reference in A1-style. Address value will contain the Sheet reference (e.g. Sheet1!A1:B4). Read-only.
addressLocal	string	Represents range reference for the specified range in the language of the user. Read-only.
cellCount	int	Number of cells in the range. Read-only.
columnCount	int	Represents the total number of columns in the range. Read-only.
columnHidden	boolean	Represents if all columns of the current range are hidden.
columnIndex	int	Represents the column number of the first cell in the range. Zero-indexed. Read-only.
formulas	Json	Represents the formula in A1-style notation.
formulasLocal	Json	Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German.
formulasR1C1	Json	Represents the formula in R1C1-style notation.
hidden	boolean	Represents if all cells of the current range are hidden. Read-only.
numberFormat	Json	Represents Excel's number format code for the given cell.
rowCount	int	Returns the total number of rows in the range. Read-only.
rowHidden	boolean	Represents if all rows of the current range are hidden.
rowIndex	int	Returns the row number of the first cell in the range. Zero-indexed. Read-only.
text	Json	Text values of the specified range. The Text value will not depend on the cell width. The # sign substitution that happens in Excel UI will not affect the text value returned by the API. Read-only.
valueTypes	Json	Represents the type of data of each cell. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only.
values	Json	Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

RangeBorder

Property	Type	Description
color	string	HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange").
id	string	Represents border identifier. The possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
sideIndex	string	Constant value that indicates the specific side of the border. The possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
style	string	One of the constants of line style specifying the line style for the border. The possible values are: None, Continuous, Dash, DashDot, DashDotDot, Dot, Double, SlantDashDot.
weight	string	Specifies the weight of the border around a range. The possible values are: Hairline, Thin, Medium, Thick.

RangeFill

Property	Type	Description
color	string	HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange")

RangeFont

Property	Type	Description
bold	boolean	Represents the bold status of font.
color	string	HTML color code representation of the text color. E.g. #FF0000 represents Red.
italic	boolean	Represents the italic status of the font.
name	string	Font name (e.g. "Calibri")
size	double	Font size.
underline	string	Type of underline applied to the font. The possible values are: None, Single, Double, SingleAccountant, DoubleAccountant.

RangeFormat

Property	Type	Description
columnWidth	double	Gets or sets the width of all colums within the range. If the column widths are not uniform, null will be returned.
horizontalAlignment	string	Represents the horizontal alignment for the specified object. The possible values are: General, Left, Center, Right, Fill, Justify, CenterAcrossSelection, Distributed.
rowHeight	double	Gets or sets the height of all rows in the range. If the row heights are not uniform null will be returned.
verticalAlignment	string	Represents the vertical alignment for the specified object. The possible values are: Top, Center, Bottom, Justify, Distributed.
wrapText	boolean	Indicates if Excel wraps the text in the object. A null value indicates that the entire range doesn't have uniform wrap setting

remoteItem

sharedDriveItem

Property	Type	Description
id	String	The unique identifier for the share being accessed.
name	String	The display name of the shared item.
owner	identitySet	Information about the owner of the shared item being referenced.

sharingInvitation

sharingLink

Property	Type	Description
application	[identity][]	The app the link is associated with.
preventsDownload	Boolean	If true then the user can only use this link to view the item on the web, and cannot use it to download the contents of the item. Only for OneDrive for Business and SharePoint.
scope	String	The scope of the link represented by this permission. Value anonymous indicates the link is usable by anyone, organization indicates the link is only usable for users signed into the same tenant.
type	String	The type of the link created.
webHtml	String	For embed links, this property contains the HTML code for an <iframe> element that will embed the item in a webpage.
webUrl	String	A URL that opens the item in the browser on the OneDrive website.

site

Property	Type	Description
createdDateTime	DateTimeOffset	The date and time the item was created. Read-only.
description	string	The descriptive text for the site.
displayName	string	The full title for the site. Read-only.
eTag	string	ETag for the item. Read-only.
id	string	The unique identifier of the item. Read-only.
lastModifiedDateTime	DateTimeOffset	The date and time the item was last modified. Read-only.
name	string	The name / title of the item.
root	root	If present, indicates that this is the root site in the site collection. Read-only.
sharepointIds	sharepointIds	Returns identifiers useful for SharePoint REST compatibility. Read-only.
siteCollection	siteCollection	Provides details about the site's site collection. Available only on the root site. Read-only.
webUrl	string (url)	URL that displays the item in the browser. Read-only.

sitePage

Property	Type	Description
contentType	contentTypeInfo	Inherited from baseItem.
createdBy	identitySet	Inherited from baseItem.
createdDateTime	DateTimeOffset	Inherited from baseItem.
description	String	Inherited from baseItem.
eTag	String	Inherited from baseItem.
id	String	Inherited from entity.
lastModifiedBy	identitySet	Inherited from baseItem.
lastModifiedDateTime	DateTimeOffset	Inherited from baseItem.
name	String	Inherited from baseItem.
pageLayout	pageLayoutType	The name of the page layout of the page. The possible values are: microsoftReserved, article, home, unknownFutureValue.
parentReference	itemReference	Inherited from baseItem.
promotionKind	pagePromotionType	Indicates the promotion kind of the sitePage. The possible values are: microsoftReserved, page, newsPost, unknownFutureValue.
publishingState	publicationFacet	The publishing status and the MM.mm version of the page.
reactions	reactionsFacet	Reactions information for the page.
showComments	Boolean	Determines whether or not to show comments at the bottom of the page.
showRecommendedPages	Boolean	Determines whether or not to show recommended pages at the bottom of the page.
thumbnailWebUrl	String	Url of the sitePage's thumbnail image
title	String	Title of the sitePage.
titleArea	titleArea	Title area on the SharePoint page.
webUrl	String	Inherited from baseItem.

subscription

Property	Type	Description
applicationId	String	Optional. Identifier of the application used to create the subscription. Read-only.
changeType	String	Required. Indicates the type of change in the subscribed resource that will raise a change notification. The supported values are: created, updated, deleted. Multiple values can be combined using a comma-separated list. Note: Drive root item and list change notifications support only the updated changeType. User and group change notifications support updated and deleted changeType. Use updated to receive notifications when user or group is created, updated or soft deleted. Use deleted to receive notifications when user or group is permanently deleted.
clientState	String	Optional. Specifies the value of the clientState property sent by the service in each change notification. The maximum length is 128 characters. The client can check that the change notification came from the service by comparing the value of the clientState property sent with the subscription with the value of the clientState property received with each change notification.
creatorId	String	Optional. Identifier of the user or service principal that created the subscription. If the app used delegated permissions to create the subscription, this field contains the id of the signed-in user the app called on behalf of. If the app used application permissions, this field contains the id of the service principal corresponding to the app. Read-only.
encryptionCertificate	String	Optional. A base64-encoded representation of a certificate with a public key used to encrypt resource data in change notifications. Optional but required when includeResourceData is true.
encryptionCertificateId	String	Optional. A custom app-provided identifier to help identify the certificate needed to decrypt resource data.
expirationDateTime	DateTimeOffset	Required. Specifies the date and time when the webhook subscription expires. The time is in UTC, and can be an amount of time from subscription creation that varies for the resource subscribed to. For the maximum supported subscription length of time, see the table below.
id	String	Optional. Unique identifier for the subscription. Read-only.
includeResourceData	Boolean	Optional. When set to true, change notifications include resource data (such as content of a chat message).
latestSupportedTlsVersion	String	Optional. Specifies the latest version of Transport Layer Security (TLS) that the notification endpoint, specified by notificationUrl, supports. The possible values are: v1_0, v1_1, v1_2, v1_3. For subscribers whose notification endpoint supports a version lower than the currently recommended version (TLS 1.2), specifying this property by a set timeline allows them to temporarily use their deprecated version of TLS before completing their upgrade to TLS 1.2. For these subscribers, not setting this property per the timeline would result in subscription operations failing. For subscribers whose notification endpoint already supports TLS 1.2, setting this property is optional. In such cases, Microsoft Graph defaults the property to v1_2.
lifecycleNotificationUrl	String	Optional. The URL of the endpoint that receives lifecycle notifications, including subscriptionRemoved, reauthorizationRequired, and missed notifications. This URL must make use of the HTTPS protocol.
notificationQueryOptions	String	Optional. OData query options for specifying value for the targeting resource. Clients receive notifications when resource reaches the state matching the query options provided here. With this new property in the subscription creation payload along with all existing properties, Webhooks will deliver notifications whenever a resource reaches the desired state mentioned in the notificationQueryOptions property. For example, when the print job is completed or when a print job resource isFetchable property value becomes true etc. Supported only for Universal Print Service. For more information, see Subscribe to change notifications from cloud printing APIs using Microsoft Graph.
notificationUrl	String	Required. The URL of the endpoint that will receive the change notifications. This URL must make use of the HTTPS protocol.
notificationUrlAppId	String	Optional. The app ID that the subscription service can use to generate the validation token. This allows the client to validate the authenticity of the notification received.
resource	String	Required. Specifies the resource that will be monitored for changes. Do not include the base URL (https://graph.microsoft.com/v1.0/). See the possible resource path values for each supported resource.

systemfacet

Table

Property	Type	Description
highlightFirstColumn	Boolean	Indicates whether the first column contains special formatting.
highlightLastColumn	Boolean	Indicates whether the last column contains special formatting.
id	string	Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
legacyId	String	Legacy Id used in older Excle clients. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
name	string	Name of the table.
showBandedRows	Boolean	Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.
showBandedColumns	Boolean	Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.
showFilterButton	Boolean	Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.
showHeaders	boolean	Indicates whether the header row is visible or not. This value can be set to show or remove the header row.
showTotals	boolean	Indicates whether the total row is visible or not. This value can be set to show or remove the total row.
style	string	Constant value that represents the Table style. The possible values are: TableStyleLight1 thru TableStyleLight21, TableStyleMedium1 thru TableStyleMedium28, TableStyleStyleDark1 thru TableStyleStyleDark11. A custom user-defined style present in the workbook can also be specified.

TableSort

Property	Type	Description
fields	WorkbookSortField collection	Represents the current conditions used to last sort the table. Read-only.
matchCase	boolean	Represents whether the casing impacted the last sort of the table. Read-only.
method	string	Represents Chinese character ordering method last used to sort the table. The possible values are: PinYin, StrokeCount. Read-only.

Thumbnail

Property	Type	Description
content	Stream	The content stream for the thumbnail.
height	Int32	The height of the thumbnail, in pixels.
sourceItemId	String	The unique identifier of the item that provided the thumbnail. This is only available when a folder thumbnail is requested.
url	String	The URL used to fetch the thumbnail content.
width	Int32	The width of the thumbnail, in pixels.

ThumbnailSet

Property	Type	Description
id	String	The id within the item. Read-only.
large	Thumbnail	A 1920x1920 scaled thumbnail.
medium	Thumbnail	A 176x176 scaled thumbnail.
small	Thumbnail	A 48x48 cropped thumbnail.
source	Thumbnail	A custom thumbnail image or the original image used to generate other thumbnails.

uploadSession

Property	Type	Description
expirationDateTime	DateTimeOffset	The date and time in UTC that the upload session will expire. The complete file must be uploaded before this expiration time is reached.
nextExpectedRanges	String collection	A collection of byte ranges that the server is missing for the file. These ranges are zero indexed and of the format "start-end" (e.g. "0-26" to indicate the first 27 bytes of the file). When uploading files as Outlook attachments, instead of a collection of ranges, this property always indicates a single value "{start}", the location in the file where the next upload should begin.
uploadUrl	String	The URL endpoint that accepts PUT requests for byte ranges of the file.

workbookApplication

Property	Type	Description
calculationMode	string	Returns the calculation mode used in the workbook. Possible values are: Automatic, AutomaticExceptTables, Manual.

workbookChart

Property	Type	Description
height	double	Represents the height, in points, of the chart object.
id	string	Gets a chart based on its position in the collection. Read-only.
left	double	The distance, in points, from the left side of the chart to the worksheet origin.
name	string	Represents the name of a chart object.
top	double	Represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
width	double	Represents the width, in points, of the chart object.

workbookChartAxis

Property	Type	Description
id	string	Unique identifier. Read-only.
majorUnit	Json	Represents the interval between two major tick marks. Can be set to a numeric value or an empty string. The returned value is always a number.
maximum	Json	Represents the maximum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minimum	Json	Represents the minimum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minorUnit	Json	Represents the interval between two minor tick marks. "Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.

workbookChartAxisTitle

Property	Type	Description
text	string	Represents the axis title.
visible	boolean	A boolean that specifies the visibility of an axis title.

workbookChartDataLabels

Property	Type	Description
position	string	DataLabelPosition value that represents the position of the data label. The possible values are: None, Center, InsideEnd, InsideBase, OutsideEnd, Left, Right, Top, Bottom, BestFit, Callout.
separator	string	String representing the separator used for the data labels on a chart.
showBubbleSize	boolean	Boolean value representing if the data label bubble size is visible or not.
showCategoryName	boolean	Boolean value representing if the data label category name is visible or not.
showLegendKey	boolean	Boolean value representing if the data label legend key is visible or not.
showPercentage	boolean	Boolean value representing if the data label percentage is visible or not.
showSeriesName	boolean	Boolean value representing if the data label series name is visible or not.
showValue	boolean	Boolean value representing if the data label value is visible or not.

workbookChartFont

Property	Type	Description
bold	boolean	Represents the bold status of font.
color	string	HTML color code representation of the text color. E.g. #FF0000 represents Red.
italic	boolean	Represents the italic status of the font.
name	string	Font name (e.g. "Calibri")
size	double	Size of the font (e.g. 11)
underline	string	Type of underline applied to the font. The possible values are: None, Single.

workbookChartGridlines

Property	Type	Description
visible	boolean	Boolean value representing if the axis gridlines are visible or not.

workbookChartLegend

Property	Type	Description
overlay	boolean	Boolean value for whether the chart legend should overlap with the main body of the chart.
position	string	Represents the position of the legend on the chart. The possible values are: Top, Bottom, Left, Right, Corner, Custom.
visible	boolean	A boolean value the represents the visibility of a ChartLegend object.

workbookChartLineFormat

Property	Type	Description
color	string	HTML color code representing the color of lines in the chart.

workbookChartPoint

Property	Type	Description
value	Json	Returns the value of a chart point. Read-only.
id	string	unique identifier

workbookChartSeries

Property	Type	Description
name	string	Represents the name of a series in a chart.

workbookChartTitle

Property	Type	Description
overlay	boolean	Boolean value representing if the chart title will overlay the chart or not.
text	string	Represents the title text of a chart.
visible	boolean	A boolean value the represents the visibility of a chart title object.

workbookComment

Property	Type	Description
content	String	The content of comment.
contentType	String	Indicates the type for the comment.
id	String	Represents the comment identifier. Read-only.

workbookCommentReply

Property	Type	Description
content	String	The content of a comment reply.
contentType	String	Indicates the type for the comment reply.
id	String	Represents the comment identifier. Read-only.

workbookIcon

Property	Type	Description
index	int	Represents the index of the icon in the given set.
set	string	Represents the set that the icon is part of. Possible values are: Invalid, ThreeArrows, ThreeArrowsGray, ThreeFlags, ThreeTrafficLights1, ThreeTrafficLights2, ThreeSigns, ThreeSymbols, ThreeSymbols2, FourArrows, FourArrowsGray, FourRedToBlack, FourRating, FourTrafficLights, FiveArrows, FiveArrowsGray, FiveRating, FiveQuarters, ThreeStars, ThreeTriangles, FiveBoxes.

workbookNamedItem

Property	Type	Description
name	string	The name of the object. Read-only.
comment	string	Represents the comment associated with this name.
scope	string	Indicates whether the name is scoped to the workbook or to a specific worksheet. Read-only.
type	string	Indicates what type of reference is associated with the name. Possible values are: String, Integer, Double, Boolean, Range. Read-only.
value	string	Represents the formula that the name is defined to refer to. E.g. =Sheet14!$B$2:$H$12, =4.75, etc. Read-only.
visible	boolean	Specifies whether the object is visible or not.

workbookOperation

Property	Type	Description
error	workbookOperationError	The error returned by the operation.
id	String	The operation id. Read-only.
resourceLocation	String	The resource URI for the result.
status	String	The current status of the operation. Possible values are: NotStarted, Running, Completed, Failed.
StatusCode	integer	Status code of the operation.

pivotTable

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

workbookRange

Property	Type	Description
address	string	Represents the range reference in A1-style. Address value will contain the Sheet reference (e.g. Sheet1!A1:B4). Read-only.
addressLocal	string	Represents range reference for the specified range in the language of the user. Read-only.
cellCount	int	Number of cells in the range. Read-only.
columnCount	int	Represents the total number of columns in the range. Read-only.
columnHidden	boolean	Represents if all columns of the current range are hidden.
columnIndex	int	Represents the column number of the first cell in the range. Zero-indexed. Read-only.
formulas	Json	Represents the formula in A1-style notation.
formulasLocal	Json	Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German.
formulasR1C1	Json	Represents the formula in R1C1-style notation.
hidden	boolean	Represents if all cells of the current range are hidden. Read-only.
numberFormat	Json	Represents Excel's number format code for the given cell.
rowCount	int	Returns the total number of rows in the range. Read-only.
rowHidden	boolean	Represents if all rows of the current range are hidden.
rowIndex	int	Returns the row number of the first cell in the range. Zero-indexed. Read-only.
text	Json	Text values of the specified range. The Text value will not depend on the cell width. The # sign substitution that happens in Excel UI will not affect the text value returned by the API. Read-only.
valueTypes	string	Represents the type of data of each cell. Possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only.
values	Json	Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

workbookRangeBorder

Property	Type	Description
color	string	HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange").
id	string	Represents border identifier. Possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
sideIndex	string	Constant value that indicates the specific side of the border. Possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
style	string	One of the constants of line style specifying the line style for the border. Possible values are: None, Continuous, Dash, DashDot, DashDotDot, Dot, Double, SlantDashDot.
weight	string	Specifies the weight of the border around a range. Possible values are: Hairline, Thin, Medium, Thick.

workbookRangeFill

Property	Type	Description
color	string	HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange")

workbookRangeFont

Property	Type	Description
bold	boolean	Represents the bold status of font.
color	string	HTML color code representation of the text color. E.g. #FF0000 represents Red.
italic	boolean	Represents the italic status of the font.
name	string	Font name (e.g. "Calibri")
size	double	Font size.
underline	String	Type of underline applied to the font. Possible values are: None, Single, Double, SingleAccountant, DoubleAccountant.

workbookRangeFormat

Property	Type	Description
columnWidth	double	Gets or sets the width of all colums within the range. If the column widths are not uniform, null will be returned.
horizontalAlignment	string	Represents the horizontal alignment for the specified object. Possible values are: General, Left, Center, Right, Fill, Justify, CenterAcrossSelection, Distributed.
rowHeight	double	Gets or sets the height of all rows in the range. If the row heights are not uniform null will be returned.
verticalAlignment	string	Represents the vertical alignment for the specified object. Possible values are: Top, Center, Bottom, Justify, Distributed.
wrapText	boolean	Indicates if Excel wraps the text in the object. A null value indicates that the entire range doesn't have uniform wrap setting

rangeView

Property	Type	Description
cellAddresses	Json	Represents the cell addresses
columnCount	Int32	Returns the number of visible columns. Read-only.
formulas	Json	Represents the formula in A1-style notation.
formulasLocal	Json	Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German.
formulasR1C1	Json	Represents the formula in R1C1-style notation.
index	Int32	Index of the range.
numberFormat	Json	Represents Excel's number format code for the given cell. Read-only.
rowCount	Int32	Returns the number of visible rows. Read-only.
text	Json	Text values of the specified range. The Text value will not depend on the cell width. The # sign substitution that happens in Excel UI will not affect the text value returned by the API. Read-only.
valueTypes	Json	Represents the type of data of each cell. Read-only. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error.
values	Json	Represents the raw values of the specified range view. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

workbookSessionInfo

Property	Type	Description
id	string	Id of the workbook session.
persistChanges	boolean	true for persistent session. false for non-persistent session (view mode)

workbookTable

Property	Type	Description
id	string	Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
name	string	Name of the table.
showHeaders	boolean	Indicates whether the header row is visible or not. This value can be set to show or remove the header row.
showTotals	boolean	Indicates whether the total row is visible or not. This value can be set to show or remove the total row.
style	string	Constant value that represents the Table style. Possible values are: TableStyleLight1 thru TableStyleLight21, TableStyleMedium1 thru TableStyleMedium28, TableStyleStyleDark1 thru TableStyleStyleDark11. A custom user-defined style present in the workbook can also be specified.
highlightFirstColumn	Boolean	Indicates whether the first column contains special formatting.
highlightLastColumn	Boolean	Indicates whether the last column contains special formatting.
showBandedColumns	Boolean	Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.
showBandedRows	Boolean	Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.
showFilterButton	Boolean	Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.
legacyId	String	Legacy Id used in older Excle clients. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.

workbookTableColumn

Property	Type	Description
id	string	Returns a unique key that identifies the column within the table. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
index	int	Returns the index number of the column within the columns collection of the table. Zero-indexed. Read-only.
name	string	Returns the name of the table column.
values	Json	Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

workbookTableRow

Property	Type	Description
index	Int32	Returns the index number of the row within the rows collection of the table. Zero-indexed. Read-only.
values	Json	Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

workbookTableSort

Property	Type	Description
matchCase	boolean	Represents whether the casing impacted the last sort of the table. Read-only.
method	string	Represents Chinese character ordering method last used to sort the table. Possible values are: PinYin, StrokeCount. Read-only.

workbookWorksheet

Property	Type	Description
id	string	Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved. Read-only.
name	string	The display name of the worksheet.
position	int	The zero-based position of the worksheet within the workbook.
visibility	string	The Visibility of the worksheet. The possible values are: Visible, Hidden, VeryHidden.

workbookWorksheetProtection

Property	Type	Description
options	workbookWorksheetProtectionOptions	Sheet protection options. Read-only.
protected	boolean	Indicates if the worksheet is protected. Read-only.

workbookWorksheetProtectionOptions

Property	Type	Description
allowAutoFilter	boolean	Represents the worksheet protection option of allowing using auto filter feature.
allowDeleteColumns	boolean	Represents the worksheet protection option of allowing deleting columns.
allowDeleteRows	boolean	Represents the worksheet protection option of allowing deleting rows.
allowFormatCells	boolean	Represents the worksheet protection option of allowing formatting cells.
allowFormatColumns	boolean	Represents the worksheet protection option of allowing formatting columns.
allowFormatRows	boolean	Represents the worksheet protection option of allowing formatting rows.
allowInsertColumns	boolean	Represents the worksheet protection option of allowing inserting columns.
allowInsertHyperlinks	boolean	Represents the worksheet protection option of allowing inserting hyperlinks.
allowInsertRows	boolean	Represents the worksheet protection option of allowing inserting rows.
allowPivotTables	boolean	Represents the worksheet protection option of allowing using pivot table feature.
allowSort	boolean	Represents the worksheet protection option of allowing using sort feature.

Worksheet

Property	Type	Description
id	string	Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved. Read-only.
name	string	The display name of the worksheet.
position	int	The zero-based position of the worksheet within the workbook.
visibility	string	The Visibility of the worksheet. The possible values are: Visible, Hidden, VeryHidden.

WorksheetProtection

Property	Type	Description
options	workbookWorksheetProtectionOptions	Sheet protection options. Read-only.
protected	boolean	Indicates if the worksheet is protected. Read-only.