Excel integration: operations for AI agents
Excel connects to Type.com as an integration. This page lists the 1765 operations documented for Claude and Codex in Type.com: 861 read, 754 write, 150 destructive.
About Excel
Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables
Categories: Analytics & Data
How to connect Excel to Type.com
- Access
- Organization connection: one shared account for the workspace.
To add the connection, follow the steps in Space connections.
Documented operations
1765 operations. Your connection's permissions determine which operations are available. API references describe the vendor surface; they do not expand your connection's credentials or access.
1765 operations listed.
Drives.drive Item
- Read
Get workbook from drives
For files that are Excel spreadsheets, access to the workbook API to work with the spreadsheet's contents. Nullable.
- Read
Get application from drives
GET /drives/{drive-id}/items/{driveItem-id}/workbook/application
- Read
Get comments from drives
Represents a collection of comments in a workbook.
- Read
Get comments from drives
Represents a collection of comments in a workbook.
- Read
Get replies from drives
The list of replies to the comment. Read-only. Nullable.
- Read
Get replies from drives
The list of replies to the comment. Read-only. Nullable.
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/comments/{workbookComment-id}/replies/$count
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/comments/$count
- Read
Get functions from drives
GET /drives/{drive-id}/items/{driveItem-id}/workbook/functions
- Read
Invoke function sessionInfoResource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/sessionInfoResource(key='{key}')
- Read
Invoke function tableRowOperationResult
This function is the last in a series of steps to create a workbookTableRow resource asynchronously. A best practice to create multiple table rows is to batch them in one create tableRow operation and carry out the operation asynchronously.
- Read
Get names from drives
Represents a collection of workbooks scoped named items (named ranges and constants). Read-only.
- Read
Get names from drives
Represents a collection of workbooks scoped named items (named ranges and constants). Read-only.
- Read
Invoke function range
Returns the range object that is associated with the name. Throws an exception if the named item's type is not a range.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
Returns the worksheet to which the named item is scoped. Available only if the item is scoped to the worksheet. Read-only.
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/$count
- Read
Get operations from drives
The status of workbook operations. Getting an operation collection is not supported, but you can get the status of a long-running operation if the Location header is returned in the response. Read-only.
- Read
Get operations from drives
The status of workbook operations. Getting an operation collection is not supported, but you can get the status of a long-running operation if the Location header is returned in the response. Read-only.
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/operations/$count
- Read
Get tables from drives
Represents a collection of tables associated with the workbook. Read-only.
- Read
Get tables from drives
Represents a collection of tables associated with the workbook. Read-only.
- Read
Get columns from drives
The list of all the columns in the table. Read-only.
- Read
Get columns from drives
The list of all the columns in the table. Read-only.
- Read
Get filter from drives
The filter applied to the column. Read-only.
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function headerRowRange
Gets the range object associated with the header row of the column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function range
Gets the range object associated with the entire column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function totalRowRange
Gets the range object associated with the totals row of the column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/count()
- Read
Invoke function itemAt
Gets a column based on its position in the collection.
- Read
Get filter from drives
The filter applied to the column. Read-only.
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function headerRowRange
Gets the range object associated with header row of the table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function range
Get the range object associated with the entire table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function totalRowRange
Gets the range object associated with totals row of the table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Get rows from drives
The list of all the rows in the table. Read-only.
- Read
Get rows from drives
The list of all the rows in the table. Read-only.
- Read
Invoke function range
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/count()
- Read
Invoke function itemAt
Gets a row based on its position in the collection.
- Read
Get sort from drives
The sorting for the table. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current table. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/count()
- Read
Invoke function itemAt
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/itemAt(index={index})
- Read
Get columns from drives
The list of all the columns in the table. Read-only.
- Read
Get rows from drives
The list of all the rows in the table. Read-only.
- Read
Get sort from drives
The sorting for the table. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current table. Read-only.
- Read
Get worksheets from drives
Represents a collection of worksheets associated with the workbook. Read-only.
- Read
Get worksheets from drives
Represents a collection of worksheets associated with the workbook. Read-only.
- Read
Get charts from drives
The list of charts that are part of the worksheet. Read-only.
- Read
Get charts from drives
The list of charts that are part of the worksheet. Read-only.
- Read
Get axes from drives
Represents chart axes. Read-only.
- Read
Get categoryAxis from drives
Represents the category axis in a chart. Read-only.
- Read
Get format from drives
Represents the formatting of a chart object, which includes line and font formatting. Read-only.
- Read
Get font from drives
Represents the font attributes (font name, font size, color, etc.) for a chart axis element. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get majorGridlines from drives
Returns a gridlines object that represents the major gridlines for the specified axis. Read-only.
- Read
Get format from drives
Represents the formatting of chart gridlines. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get minorGridlines from drives
Returns a Gridlines object that represents the minor gridlines for the specified axis. Read-only.
- Read
Get format from drives
Represents the formatting of chart gridlines. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get title from drives
Represents the axis title. Read-only.
- Read
Get format from drives
Represents the formatting of chart axis title. Read-only.
- Read
Get font from drives
Represents the font attributes, such as font name, font size, color, etc. of chart axis title object. Read-only.
- Read
Get seriesAxis from drives
Represents the series axis of a 3-dimensional chart. Read-only.
- Read
Get format from drives
Represents the formatting of a chart object, which includes line and font formatting. Read-only.
- Read
Get font from drives
Represents the font attributes (font name, font size, color, etc.) for a chart axis element. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get majorGridlines from drives
Returns a gridlines object that represents the major gridlines for the specified axis. Read-only.
- Read
Get format from drives
Represents the formatting of chart gridlines. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get minorGridlines from drives
Returns a Gridlines object that represents the minor gridlines for the specified axis. Read-only.
- Read
Get format from drives
Represents the formatting of chart gridlines. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get title from drives
Represents the axis title. Read-only.
- Read
Get format from drives
Represents the formatting of chart axis title. Read-only.
- Read
Get font from drives
Represents the font attributes, such as font name, font size, color, etc. of chart axis title object. Read-only.
- Read
Get valueAxis from drives
Represents the value axis in an axis. Read-only.
- Read
Get format from drives
Represents the formatting of a chart object, which includes line and font formatting. Read-only.
- Read
Get font from drives
Represents the font attributes (font name, font size, color, etc.) for a chart axis element. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get majorGridlines from drives
Returns a gridlines object that represents the major gridlines for the specified axis. Read-only.
- Read
Get format from drives
Represents the formatting of chart gridlines. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get minorGridlines from drives
Returns a Gridlines object that represents the minor gridlines for the specified axis. Read-only.
- Read
Get format from drives
Represents the formatting of chart gridlines. Read-only.
- Read
Get line from drives
Represents chart line formatting. Read-only.
- Read
Get title from drives
Represents the axis title. Read-only.
- Read
Get format from drives
Represents the formatting of chart axis title. Read-only.
- Read
Get font from drives
Represents the font attributes, such as font name, font size, color, etc. of chart axis title object. Read-only.
- Read
Get dataLabels from drives
Represents the data labels on the chart. Read-only.
- Read
Get format from drives
Represents the format of chart data labels, which includes fill and font formatting. Read-only.
- Read
Get fill from drives
Represents the fill format of the current chart data label. Read-only.
- Read
Get font from drives
Represents the font attributes (font name, font size, color, etc.) for a chart data label. Read-only.
- Read
Get format from drives
Encapsulates the format properties for the chart area. Read-only.
- Read
Get fill from drives
Represents the fill format of an object, which includes background formatting information. Read-only.
- Read
Get font from drives
Represents the font attributes (font name, font size, color, etc.) for the current object. Read-only.
- Read
Get legend from drives
Represents the legend for the chart. Read-only.
- Read
Get format from drives
Represents the formatting of a chart legend, which includes fill and font formatting. Read-only.
- Read
Get fill from drives
Represents the fill format of an object, which includes background formating information. Read-only.
- Read
Get font from drives
Represents the font attributes such as font name, font size, color, etc. of a chart legend. Read-only.
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/image()
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/image(width={width},height={height},fittingMode='{fittingMode}')
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/image(width={width},height={height})
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/image(width={width})
- Read
Get series from drives
Represents either a single series or collection of series in the chart. Read-only.
- Read
Get series from drives
Represents either a single series or collection of series in the chart. Read-only.
- Read
Get format from drives
The formatting of a chart series, which includes fill and line formatting. Read-only.
- Read
Get fill from drives
Represents the fill format of a chart series, which includes background formatting information. Read-only.
- Read
Get line from drives
Represents line formatting. Read-only.
- Read
Get points from drives
A collection of all points in the series. Read-only.
- Read
Get points from drives
A collection of all points in the series. Read-only.
- Read
Get format from drives
The format properties of the chart point. Read-only.
- Read
Get fill from drives
Represents the fill format of a chart, which includes background formatting information. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/count()
- Read
Invoke function itemAt
Retrieve a point based on its position within the series.
- Read
Get format from drives
The format properties of the chart point. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/count()
- Read
Invoke function itemAt
Retrieves a series based on its position in the collection
- Read
Get format from drives
The formatting of a chart series, which includes fill and line formatting. Read-only.
- Read
Get points from drives
A collection of all points in the series. Read-only.
- Read
Get title from drives
Represents the title of the specified chart, including the text, visibility, position and formatting of the title. Read-only.
- Read
Get format from drives
The formatting of a chart title, which includes fill and font formatting. Read-only.
- Read
Get fill from drives
Represents the fill format of an object, which includes background formatting information. Read-only.
- Read
Get font from drives
Represents the font attributes (font name, font size, color, etc.) for the current object. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current chart. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/count()
- Read
Invoke function item
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')
- Read
Get axes from drives
Represents chart axes. Read-only.
- Read
Get dataLabels from drives
Represents the data labels on the chart. Read-only.
- Read
Get format from drives
Encapsulates the format properties for the chart area. Read-only.
- Read
Get legend from drives
Represents the legend for the chart. Read-only.
- Read
Get series from drives
Represents either a single series or collection of series in the chart. Read-only.
- Read
Get title from drives
Represents the title of the specified chart, including the text, visibility, position and formatting of the title. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current chart. Read-only.
- Read
Invoke function itemAt
Gets a chart based on its position in the collection.
- Read
Get axes from drives
Represents chart axes. Read-only.
- Read
Get dataLabels from drives
Represents the data labels on the chart. Read-only.
- Read
Get format from drives
Encapsulates the format properties for the chart area. Read-only.
- Read
Get legend from drives
Represents the legend for the chart. Read-only.
- Read
Get series from drives
Represents either a single series or collection of series in the chart. Read-only.
- Read
Get title from drives
Represents the title of the specified chart, including the text, visibility, position and formatting of the title. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current chart. Read-only.
- Read
Invoke function cell
Gets the range object containing the single cell based on row and column numbers. The cell can be outside the bounds of its parent range, so long as it's stays within the worksheet grid.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function range
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function range
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Get names from drives
The list of names that are associated with the worksheet. Read-only.
- Read
Get names from drives
The list of names that are associated with the worksheet. Read-only.
- Read
Invoke function range
Returns the range object that is associated with the name. Throws an exception if the named item's type is not a range.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
Returns the worksheet to which the named item is scoped. Available only if the item is scoped to the worksheet. Read-only.
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/$count
- Read
Get pivotTables from drives
The list of piot tables that are part of the worksheet.
- Read
Get pivotTables from drives
The list of piot tables that are part of the worksheet.
- Read
Get worksheet from drives
The worksheet that contains the current pivot table. Read-only.
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/pivotTables/$count
- Read
Get protection from drives
The sheet protection object for a worksheet. Read-only.
- Read
Get tables from drives
The list of tables that are part of the worksheet. Read-only.
- Read
Get tables from drives
The list of tables that are part of the worksheet. Read-only.
- Read
Get columns from drives
The list of all the columns in the table. Read-only.
- Read
Get columns from drives
The list of all the columns in the table. Read-only.
- Read
Get filter from drives
The filter applied to the column. Read-only.
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function headerRowRange
Gets the range object associated with the header row of the column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function range
Gets the range object associated with the entire column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function totalRowRange
Gets the range object associated with the totals row of the column.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/count()
- Read
Invoke function itemAt
Gets a column based on its position in the collection.
- Read
Get filter from drives
The filter applied to the column. Read-only.
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function headerRowRange
Gets the range object associated with header row of the table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function range
Get the range object associated with the entire table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function totalRowRange
Gets the range object associated with totals row of the table.
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Get rows from drives
The list of all the rows in the table. Read-only.
- Read
Get rows from drives
The list of all the rows in the table. Read-only.
- Read
Invoke function range
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()
- Read
Get format from drives
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
- Read
Get sort from drives
The worksheet containing the current range. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current range. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/count()
- Read
Invoke function itemAt
Gets a row based on its position in the collection.
- Read
Get sort from drives
The sorting for the table. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current table. Read-only.
- Read
Invoke function count
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/count()
- Read
Invoke function itemAt
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/itemAt(index={index})
- Read
Get columns from drives
The list of all the columns in the table. Read-only.
- Read
Get rows from drives
The list of all the rows in the table. Read-only.
- Read
Get sort from drives
The sorting for the table. Read-only.
- Read
Get worksheet from drives
The worksheet containing the current table. Read-only.
- Read
Get the number of the resource
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/$count
- Write
Update the navigation property workbook in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook
- Write
Update the navigation property application in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/application
- Write
Invoke action calculate
Recalculate all currently opened workbooks in Excel.
- Write
Create new navigation property to comments for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/comments
- Write
Update the navigation property comments in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/comments/{workbookComment-id}
- Write
Create new navigation property to replies for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/comments/{workbookComment-id}/replies
- Write
Update the navigation property replies in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/comments/{workbookComment-id}/replies/{workbookCommentReply-id}
- Write
Update the navigation property functions in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/functions
- Write
Invoke action abs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/abs
- Write
Invoke action accrInt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/accrInt
- Write
Invoke action accrIntM
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/accrIntM
- Write
Invoke action acos
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/acos
- Write
Invoke action acosh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/acosh
- Write
Invoke action acot
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/acot
- Write
Invoke action acoth
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/acoth
- Write
Invoke action amorDegrc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/amorDegrc
- Write
Invoke action amorLinc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/amorLinc
- Write
Invoke action and
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/and
- Write
Invoke action arabic
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/arabic
- Write
Invoke action areas
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/areas
- Write
Invoke action asc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/asc
- Write
Invoke action asin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/asin
- Write
Invoke action asinh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/asinh
- Write
Invoke action atan
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/atan
- Write
Invoke action atan2
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/atan2
- Write
Invoke action atanh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/atanh
- Write
Invoke action aveDev
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/aveDev
- Write
Invoke action average
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/average
- Write
Invoke action averageA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/averageA
- Write
Invoke action averageIf
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/averageIf
- Write
Invoke action averageIfs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/averageIfs
- Write
Invoke action bahtText
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bahtText
- Write
Invoke action base
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/base
- Write
Invoke action besselI
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/besselI
- Write
Invoke action besselJ
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/besselJ
- Write
Invoke action besselK
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/besselK
- Write
Invoke action besselY
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/besselY
- Write
Invoke action betaDist
Invoke action betaDist
- Write
Invoke action betaInv
Invoke action betaInv
- Write
Invoke action bin2Dec
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bin2Dec
- Write
Invoke action bin2Hex
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bin2Hex
- Write
Invoke action bin2Oct
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bin2Oct
- Write
Invoke action binomDist
Invoke action binomDist
- Write
Invoke action binomDistRange
Invoke action binomDistRange
- Write
Invoke action binomInv
Invoke action binomInv
- Write
Invoke action bitand
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bitand
- Write
Invoke action bitlshift
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bitlshift
- Write
Invoke action bitor
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bitor
- Write
Invoke action bitrshift
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bitrshift
- Write
Invoke action bitxor
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/bitxor
- Write
Invoke action ceilingMath
Invoke action ceilingMath
- Write
Invoke action ceilingPrecise
Invoke action ceilingPrecise
- Write
Invoke action char
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/char
- Write
Invoke action chiSqDist
Invoke action chiSqDist
- Write
Invoke action chiSqDistRT
Invoke action chiSqDistRT
- Write
Invoke action chiSqInv
Invoke action chiSqInv
- Write
Invoke action chiSqInvRT
Invoke action chiSqInvRT
- Write
Invoke action choose
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/choose
- Write
Invoke action clean
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/clean
- Write
Invoke action code
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/code
- Write
Invoke action columns
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/columns
- Write
Invoke action combin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/combin
- Write
Invoke action combina
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/combina
- Write
Invoke action complex
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/complex
- Write
Invoke action concatenate
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/concatenate
- Write
Invoke action confidenceNorm
Invoke action confidenceNorm
- Write
Invoke action confidenceT
Invoke action confidenceT
- Write
Invoke action convert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/convert
- Write
Invoke action cos
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/cos
- Write
Invoke action cosh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/cosh
- Write
Invoke action cot
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/cot
- Write
Invoke action coth
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coth
- Write
Invoke action count
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/count
- Write
Invoke action countA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/countA
- Write
Invoke action countBlank
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/countBlank
- Write
Invoke action countIf
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/countIf
- Write
Invoke action countIfs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/countIfs
- Write
Invoke action coupDayBs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coupDayBs
- Write
Invoke action coupDays
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coupDays
- Write
Invoke action coupDaysNc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coupDaysNc
- Write
Invoke action coupNcd
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coupNcd
- Write
Invoke action coupNum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coupNum
- Write
Invoke action coupPcd
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/coupPcd
- Write
Invoke action csc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/csc
- Write
Invoke action csch
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/csch
- Write
Invoke action cumIPmt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/cumIPmt
- Write
Invoke action cumPrinc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/cumPrinc
- Write
Invoke action date
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/date
- Write
Invoke action datevalue
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/datevalue
- Write
Invoke action daverage
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/daverage
- Write
Invoke action day
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/day
- Write
Invoke action days
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/days
- Write
Invoke action days360
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/days360
- Write
Invoke action db
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/db
- Write
Invoke action dbcs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dbcs
- Write
Invoke action dcount
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dcount
- Write
Invoke action dcountA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dcountA
- Write
Invoke action ddb
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/ddb
- Write
Invoke action dec2Bin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dec2Bin
- Write
Invoke action dec2Hex
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dec2Hex
- Write
Invoke action dec2Oct
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dec2Oct
- Write
Invoke action decimal
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/decimal
- Write
Invoke action degrees
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/degrees
- Write
Invoke action delta
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/delta
- Write
Invoke action devSq
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/devSq
- Write
Invoke action dget
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dget
- Write
Invoke action disc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/disc
- Write
Invoke action dmax
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dmax
- Write
Invoke action dmin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dmin
- Write
Invoke action dollar
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dollar
- Write
Invoke action dollarDe
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dollarDe
- Write
Invoke action dollarFr
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dollarFr
- Write
Invoke action dproduct
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dproduct
- Write
Invoke action dstDev
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dstDev
- Write
Invoke action dstDevP
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dstDevP
- Write
Invoke action dsum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dsum
- Write
Invoke action duration
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/duration
- Write
Invoke action dvar
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dvar
- Write
Invoke action dvarP
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/dvarP
- Write
Invoke action ecmaCeiling
Invoke action ecmaCeiling
- Write
Invoke action edate
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/edate
- Write
Invoke action effect
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/effect
- Write
Invoke action eoMonth
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/eoMonth
- Write
Invoke action erf
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/erf
- Write
Invoke action erfPrecise
Invoke action erfPrecise
- Write
Invoke action erfC
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/erfC
- Write
Invoke action erfCPrecise
Invoke action erfCPrecise
- Write
Invoke action errorType
Invoke action errorType
- Write
Invoke action even
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/even
- Write
Invoke action exact
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/exact
- Write
Invoke action exp
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/exp
- Write
Invoke action exponDist
Invoke action exponDist
- Write
Invoke action fDist
Invoke action fDist
- Write
Invoke action fDistRT
Invoke action fDistRT
- Write
Invoke action fInv
Invoke action fInv
- Write
Invoke action fInvRT
Invoke action fInvRT
- Write
Invoke action fact
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/fact
- Write
Invoke action factDouble
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/factDouble
- Write
Invoke action false
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/false
- Write
Invoke action find
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/find
- Write
Invoke action findB
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/findB
- Write
Invoke action fisher
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/fisher
- Write
Invoke action fisherInv
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/fisherInv
- Write
Invoke action fixed
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/fixed
- Write
Invoke action floorMath
Invoke action floorMath
- Write
Invoke action floorPrecise
Invoke action floorPrecise
- Write
Invoke action fv
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/fv
- Write
Invoke action fvschedule
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/fvschedule
- Write
Invoke action gamma
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/gamma
- Write
Invoke action gammaDist
Invoke action gammaDist
- Write
Invoke action gammaInv
Invoke action gammaInv
- Write
Invoke action gammaLn
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/gammaLn
- Write
Invoke action gammaLnPrecise
Invoke action gammaLnPrecise
- Write
Invoke action gauss
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/gauss
- Write
Invoke action gcd
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/gcd
- Write
Invoke action geoMean
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/geoMean
- Write
Invoke action geStep
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/geStep
- Write
Invoke action harMean
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/harMean
- Write
Invoke action hex2Bin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/hex2Bin
- Write
Invoke action hex2Dec
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/hex2Dec
- Write
Invoke action hex2Oct
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/hex2Oct
- Write
Invoke action hlookup
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/hlookup
- Write
Invoke action hour
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/hour
- Write
Invoke action hyperlink
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/hyperlink
- Write
Invoke action hypGeomDist
Invoke action hypGeomDist
- Write
Invoke action if
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/if
- Write
Invoke action imAbs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imAbs
- Write
Invoke action imaginary
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imaginary
- Write
Invoke action imArgument
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imArgument
- Write
Invoke action imConjugate
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imConjugate
- Write
Invoke action imCos
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imCos
- Write
Invoke action imCosh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imCosh
- Write
Invoke action imCot
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imCot
- Write
Invoke action imCsc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imCsc
- Write
Invoke action imCsch
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imCsch
- Write
Invoke action imDiv
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imDiv
- Write
Invoke action imExp
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imExp
- Write
Invoke action imLn
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imLn
- Write
Invoke action imLog10
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imLog10
- Write
Invoke action imLog2
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imLog2
- Write
Invoke action imPower
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imPower
- Write
Invoke action imProduct
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imProduct
- Write
Invoke action imReal
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imReal
- Write
Invoke action imSec
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSec
- Write
Invoke action imSech
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSech
- Write
Invoke action imSin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSin
- Write
Invoke action imSinh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSinh
- Write
Invoke action imSqrt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSqrt
- Write
Invoke action imSub
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSub
- Write
Invoke action imSum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imSum
- Write
Invoke action imTan
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/imTan
- Write
Invoke action int
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/int
- Write
Invoke action intRate
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/intRate
- Write
Invoke action ipmt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/ipmt
- Write
Invoke action irr
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/irr
- Write
Invoke action isErr
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isErr
- Write
Invoke action isError
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isError
- Write
Invoke action isEven
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isEven
- Write
Invoke action isFormula
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isFormula
- Write
Invoke action isLogical
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isLogical
- Write
Invoke action isNA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isNA
- Write
Invoke action isNonText
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isNonText
- Write
Invoke action isNumber
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isNumber
- Write
Invoke action isoCeiling
Invoke action isoCeiling
- Write
Invoke action isOdd
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isOdd
- Write
Invoke action isoWeekNum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isoWeekNum
- Write
Invoke action ispmt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/ispmt
- Write
Invoke action isref
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isref
- Write
Invoke action isText
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/isText
- Write
Invoke action kurt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/kurt
- Write
Invoke action large
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/large
- Write
Invoke action lcm
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/lcm
- Write
Invoke action left
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/left
- Write
Invoke action leftb
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/leftb
- Write
Invoke action len
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/len
- Write
Invoke action lenb
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/lenb
- Write
Invoke action ln
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/ln
- Write
Invoke action log
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/log
- Write
Invoke action log10
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/log10
- Write
Invoke action logNormDist
Invoke action logNormDist
- Write
Invoke action logNormInv
Invoke action logNormInv
- Write
Invoke action lookup
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/lookup
- Write
Invoke action lower
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/lower
- Write
Invoke action match
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/match
- Write
Invoke action max
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/max
- Write
Invoke action maxA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/maxA
- Write
Invoke action mduration
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/mduration
- Write
Invoke action median
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/median
- Write
Invoke action mid
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/mid
- Write
Invoke action midb
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/midb
- Write
Invoke action min
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/min
- Write
Invoke action minA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/minA
- Write
Invoke action minute
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/minute
- Write
Invoke action mirr
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/mirr
- Write
Invoke action mod
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/mod
- Write
Invoke action month
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/month
- Write
Invoke action mround
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/mround
- Write
Invoke action multiNomial
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/multiNomial
- Write
Invoke action n
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/n
- Write
Invoke action na
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/na
- Write
Invoke action negBinomDist
Invoke action negBinomDist
- Write
Invoke action networkDays
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/networkDays
- Write
Invoke action networkDaysIntl
Invoke action networkDaysIntl
- Write
Invoke action nominal
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/nominal
- Write
Invoke action normDist
Invoke action normDist
- Write
Invoke action normInv
Invoke action normInv
- Write
Invoke action normSDist
Invoke action normSDist
- Write
Invoke action normSInv
Invoke action normSInv
- Write
Invoke action not
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/not
- Write
Invoke action now
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/now
- Write
Invoke action nper
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/nper
- Write
Invoke action npv
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/npv
- Write
Invoke action numberValue
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/numberValue
- Write
Invoke action oct2Bin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oct2Bin
- Write
Invoke action oct2Dec
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oct2Dec
- Write
Invoke action oct2Hex
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oct2Hex
- Write
Invoke action odd
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/odd
- Write
Invoke action oddFPrice
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oddFPrice
- Write
Invoke action oddFYield
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oddFYield
- Write
Invoke action oddLPrice
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oddLPrice
- Write
Invoke action oddLYield
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/oddLYield
- Write
Invoke action or
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/or
- Write
Invoke action pduration
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/pduration
- Write
Invoke action percentileExc
Invoke action percentileExc
- Write
Invoke action percentileInc
Invoke action percentileInc
- Write
Invoke action percentRankExc
Invoke action percentRankExc
- Write
Invoke action percentRankInc
Invoke action percentRankInc
- Write
Invoke action permut
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/permut
- Write
Invoke action permutationa
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/permutationa
- Write
Invoke action phi
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/phi
- Write
Invoke action pi
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/pi
- Write
Invoke action pmt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/pmt
- Write
Invoke action poissonDist
Invoke action poissonDist
- Write
Invoke action power
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/power
- Write
Invoke action ppmt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/ppmt
- Write
Invoke action price
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/price
- Write
Invoke action priceDisc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/priceDisc
- Write
Invoke action priceMat
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/priceMat
- Write
Invoke action product
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/product
- Write
Invoke action proper
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/proper
- Write
Invoke action pv
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/pv
- Write
Invoke action quartileExc
Invoke action quartileExc
- Write
Invoke action quartileInc
Invoke action quartileInc
- Write
Invoke action quotient
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/quotient
- Write
Invoke action radians
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/radians
- Write
Invoke action rand
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/rand
- Write
Invoke action randBetween
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/randBetween
- Write
Invoke action rankAvg
Invoke action rankAvg
- Write
Invoke action rankEq
Invoke action rankEq
- Write
Invoke action rate
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/rate
- Write
Invoke action received
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/received
- Write
Invoke action replace
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/replace
- Write
Invoke action replaceB
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/replaceB
- Write
Invoke action rept
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/rept
- Write
Invoke action right
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/right
- Write
Invoke action rightb
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/rightb
- Write
Invoke action roman
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/roman
- Write
Invoke action round
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/round
- Write
Invoke action roundDown
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/roundDown
- Write
Invoke action roundUp
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/roundUp
- Write
Invoke action rows
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/rows
- Write
Invoke action rri
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/rri
- Write
Invoke action sec
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sec
- Write
Invoke action sech
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sech
- Write
Invoke action second
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/second
- Write
Invoke action seriesSum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/seriesSum
- Write
Invoke action sheet
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sheet
- Write
Invoke action sheets
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sheets
- Write
Invoke action sign
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sign
- Write
Invoke action sin
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sin
- Write
Invoke action sinh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sinh
- Write
Invoke action skew
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/skew
- Write
Invoke action skewp
Invoke action skewp
- Write
Invoke action sln
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sln
- Write
Invoke action small
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/small
- Write
Invoke action sqrt
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sqrt
- Write
Invoke action sqrtPi
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sqrtPi
- Write
Invoke action standardize
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/standardize
- Write
Invoke action stDevP
Invoke action stDevP
- Write
Invoke action stDevS
Invoke action stDevS
- Write
Invoke action stDevA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/stDevA
- Write
Invoke action stDevPA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/stDevPA
- Write
Invoke action substitute
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/substitute
- Write
Invoke action subtotal
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/subtotal
- Write
Invoke action sum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sum
- Write
Invoke action sumIf
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sumIf
- Write
Invoke action sumIfs
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sumIfs
- Write
Invoke action sumSq
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/sumSq
- Write
Invoke action syd
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/syd
- Write
Invoke action t
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/t
- Write
Invoke action tDist
Invoke action tDist
- Write
Invoke action tDist2T
Invoke action tDist2T
- Write
Invoke action tDistRT
Invoke action tDistRT
- Write
Invoke action tInv
Invoke action tInv
- Write
Invoke action tInv2T
Invoke action tInv2T
- Write
Invoke action tan
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/tan
- Write
Invoke action tanh
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/tanh
- Write
Invoke action tbillEq
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/tbillEq
- Write
Invoke action tbillPrice
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/tbillPrice
- Write
Invoke action tbillYield
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/tbillYield
- Write
Invoke action text
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/text
- Write
Invoke action time
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/time
- Write
Invoke action timevalue
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/timevalue
- Write
Invoke action today
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/today
- Write
Invoke action trim
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/trim
- Write
Invoke action trimMean
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/trimMean
- Write
Invoke action true
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/true
- Write
Invoke action trunc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/trunc
- Write
Invoke action type
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/type
- Write
Invoke action unichar
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/unichar
- Write
Invoke action unicode
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/unicode
- Write
Invoke action upper
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/upper
- Write
Invoke action usdollar
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/usdollar
- Write
Invoke action value
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/value
- Write
Invoke action varP
Invoke action varP
- Write
Invoke action varS
Invoke action varS
- Write
Invoke action varA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/varA
- Write
Invoke action varPA
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/varPA
- Write
Invoke action vdb
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/vdb
- Write
Invoke action vlookup
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/vlookup
- Write
Invoke action weekday
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/weekday
- Write
Invoke action weekNum
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/weekNum
- Write
Invoke action weibullDist
Invoke action weibullDist
- Write
Invoke action workDay
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/workDay
- Write
Invoke action workDayIntl
Invoke action workDayIntl
- Write
Invoke action xirr
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/xirr
- Write
Invoke action xnpv
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/xnpv
- Write
Invoke action xor
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/xor
- Write
Invoke action year
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/year
- Write
Invoke action yearFrac
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/yearFrac
- Write
Invoke action yield
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/yield
- Write
Invoke action yieldDisc
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/yieldDisc
- Write
Invoke action yieldMat
POST /drives/{drive-id}/items/{driveItem-id}/workbook/functions/yieldMat
- Write
Invoke action zTest
Invoke action zTest
- Write
Invoke action closeSession
Use this API to close an existing workbook session.
- Write
Invoke action createSession
Create a new workbook session. Excel APIs can be called in one of two modes: To represent the session in the API, use the workbook-session-id: {session-id} header. In some cases, creating a new session requires an indeterminate time to complete.
- Write
Invoke action refreshSession
Use this API to refresh an existing workbook session.
- Write
Create new navigation property to names for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/names
- Write
Update the navigation property names in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/sort
- Write
Invoke action add
Adds a new name to the collection of the given scope using the user's locale for the formula.
- Write
Invoke action addFormulaLocal
Adds a new name to the collection of the given scope using the user's locale for the formula.
- Write
Create new navigation property to operations for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/operations
- Write
Update the navigation property operations in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/operations/{workbookOperation-id}
- Write
Create new navigation property to tables for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables
- Write
Update the navigation property tables in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}
- Write
Create new navigation property to columns for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns
- Write
Update the navigation property columns in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}
- Write
Update the navigation property filter in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter
- Write
Invoke action apply
Apply the given filter criteria on the given column.
- Write
Invoke action applyBottomItemsFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyBottomItemsFilter
- Write
Invoke action applyBottomPercentFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyBottomPercentFilter
- Write
Invoke action applyCellColorFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyCellColorFilter
- Write
Invoke action applyCustomFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyCustomFilter
- Write
Invoke action applyDynamicFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyDynamicFilter
- Write
Invoke action applyFontColorFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyFontColorFilter
- Write
Invoke action applyIconFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyIconFilter
- Write
Invoke action applyTopItemsFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyTopItemsFilter
- Write
Invoke action applyTopPercentFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyTopPercentFilter
- Write
Invoke action applyValuesFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyValuesFilter
- Write
Invoke action clear
Clear the filter on the given column.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/sort
- Write
Invoke action add
Adds a new column to the table.
- Write
Update the navigation property filter in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/itemAt(index={index})/filter
- Write
Invoke action clearFilters
Clears all the filters currently applied on the table.
- Write
Invoke action convertToRange
Converts the table into a normal range of cells. All data is preserved.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/sort
- Write
Invoke action reapplyFilters
Reapplies all the filters currently on the table.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/sort
- Write
Create new navigation property to rows for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows
- Write
Update the navigation property rows in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/sort
- Write
Invoke action add
Adds rows to the end of the table. Note that the API can accept multiple rows data using this API. Adding one row at a time could lead to performance degradation. The recommended approach would be to batch the rows together in a single call rather than doing single row insertion.
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/sort
- Write
Invoke action apply
Perform a sort operation.
- Write
Invoke action clear
Clears the sorting that is currently on the table. While this doesn't modify the table's ordering, it clears the state of the header buttons.
- Write
Invoke action reapply
Reapplies the current sorting parameters to the table.
- Write
Invoke action add
Create a new table. The range source address determines the worksheet under which the table will be added. If the table can't be added (for example, because the address is invalid, or the table would overlap with another table), an error is generated.
- Write
Create new navigation property to columns for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/itemAt(index={index})/columns
- Write
Create new navigation property to rows for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/itemAt(index={index})/rows
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/tables/itemAt(index={index})/sort
- Write
Create new navigation property to worksheets for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets
- Write
Update the navigation property worksheets in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}
- Write
Create new navigation property to charts for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts
- Write
Update the navigation property charts in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}
- Write
Update the navigation property axes in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes
- Write
Update the navigation property categoryAxis in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/format
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/format/font
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property majorGridlines in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/majorGridlines
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/majorGridlines/format
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/majorGridlines/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property minorGridlines in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/minorGridlines
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/minorGridlines/format
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/minorGridlines/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property title in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/title
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/title/format
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/title/format/font
- Write
Update the navigation property seriesAxis in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/format
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/format/font
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property majorGridlines in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/majorGridlines
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/majorGridlines/format
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/majorGridlines/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property minorGridlines in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/minorGridlines
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/minorGridlines/format
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/minorGridlines/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property title in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/title
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/title/format
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/title/format/font
- Write
Update the navigation property valueAxis in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/format
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/format/font
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property majorGridlines in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/majorGridlines
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/majorGridlines/format
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/majorGridlines/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property minorGridlines in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/minorGridlines
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/minorGridlines/format
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/minorGridlines/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Update the navigation property title in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/title
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/title/format
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/title/format/font
- Write
Update the navigation property dataLabels in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels/format
- Write
Update the navigation property fill in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels/format/fill
- Write
Invoke action clear
Clear the fill color of a chart element.
- Write
Invoke action setSolidColor
Sets the fill formatting of a chart element to a uniform color.
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels/format/font
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/format
- Write
Update the navigation property fill in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/format/fill
- Write
Invoke action clear
Clear the fill color of a chart element.
- Write
Invoke action setSolidColor
Sets the fill formatting of a chart element to a uniform color.
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/format/font
- Write
Update the navigation property legend in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend/format
- Write
Update the navigation property fill in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend/format/fill
- Write
Invoke action clear
Clear the fill color of a chart element.
- Write
Invoke action setSolidColor
Sets the fill formatting of a chart element to a uniform color.
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend/format/font
- Write
Invoke action setData
Resets the source data for the chart.
- Write
Invoke action setPosition
Positions the chart relative to cells on the worksheet.
- Write
Create new navigation property to series for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series
- Write
Update the navigation property series in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/format
- Write
Update the navigation property fill in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/format/fill
- Write
Invoke action clear
Clear the fill color of a chart element.
- Write
Invoke action setSolidColor
Sets the fill formatting of a chart element to a uniform color.
- Write
Update the navigation property line in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/format/line
- Write
Invoke action clear
Clear the line format of a chart element.
- Write
Create new navigation property to points for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points
- Write
Update the navigation property points in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/{workbookChartPoint-id}
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/{workbookChartPoint-id}/format
- Write
Update the navigation property fill in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/{workbookChartPoint-id}/format/fill
- Write
Invoke action clear
Clear the fill color of a chart element.
- Write
Invoke action setSolidColor
Sets the fill formatting of a chart element to a uniform color.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/itemAt(index={index})/format
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/itemAt(index={index})/format
- Write
Create new navigation property to points for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/itemAt(index={index})/points
- Write
Update the navigation property title in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title/format
- Write
Update the navigation property fill in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title/format/fill
- Write
Invoke action clear
Clear the fill color of a chart element.
- Write
Invoke action setSolidColor
Sets the fill formatting of a chart element to a uniform color.
- Write
Update the navigation property font in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title/format/font
- Write
Invoke action add
Creates a new chart.
- Write
Update the navigation property axes in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/axes
- Write
Update the navigation property dataLabels in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/dataLabels
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/format
- Write
Update the navigation property legend in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/legend
- Write
Create new navigation property to series for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/series
- Write
Update the navigation property title in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/title
- Write
Update the navigation property axes in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/axes
- Write
Update the navigation property dataLabels in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/dataLabels
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/format
- Write
Update the navigation property legend in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/legend
- Write
Create new navigation property to series for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/series
- Write
Update the navigation property title in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/title
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/sort
- Write
Create new navigation property to names for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names
- Write
Update the navigation property names in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/sort
- Write
Invoke action add
Adds a new name to the collection of the given scope using the user's locale for the formula.
- Write
Invoke action addFormulaLocal
Adds a new name to the collection of the given scope using the user's locale for the formula.
- Write
Create new navigation property to pivotTables for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/pivotTables
- Write
Update the navigation property pivotTables in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/pivotTables/{workbookPivotTable-id}
- Write
Invoke action refresh
Refreshes the PivotTable.
- Write
Invoke action refreshAll
Refreshes the PivotTable within a given worksheet.
- Write
Update the navigation property protection in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/protection
- Write
Invoke action protect
Protect a worksheet. It throws if the worksheet has been protected.
- Write
Invoke action unprotect
Unprotect a worksheet
- Write
Create new navigation property to tables for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables
- Write
Update the navigation property tables in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}
- Write
Create new navigation property to columns for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns
- Write
Update the navigation property columns in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}
- Write
Update the navigation property filter in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter
- Write
Invoke action apply
Apply the given filter criteria on the given column.
- Write
Invoke action applyBottomItemsFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyBottomItemsFilter
- Write
Invoke action applyBottomPercentFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyBottomPercentFilter
- Write
Invoke action applyCellColorFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyCellColorFilter
- Write
Invoke action applyCustomFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyCustomFilter
- Write
Invoke action applyDynamicFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyDynamicFilter
- Write
Invoke action applyFontColorFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyFontColorFilter
- Write
Invoke action applyIconFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyIconFilter
- Write
Invoke action applyTopItemsFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyTopItemsFilter
- Write
Invoke action applyTopPercentFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyTopPercentFilter
- Write
Invoke action applyValuesFilter
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter/applyValuesFilter
- Write
Invoke action clear
Clear the filter on the given column.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/sort
- Write
Invoke action add
Adds a new column to the table.
- Write
Update the navigation property filter in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/itemAt(index={index})/filter
- Write
Invoke action clearFilters
Clears all the filters currently applied on the table.
- Write
Invoke action convertToRange
Converts the table into a normal range of cells. All data is preserved.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/sort
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/sort
- Write
Invoke action reapplyFilters
Reapplies all the filters currently on the table.
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/sort
- Write
Create new navigation property to rows for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows
- Write
Update the navigation property rows in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}
- Write
Update the navigation property format in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/format
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/sort
- Write
Invoke action add
Adds rows to the end of the table. Note that the API can accept multiple rows data using this API. Adding one row at a time could lead to performance degradation. The recommended approach would be to batch the rows together in a single call rather than doing single row insertion.
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/sort
- Write
Invoke action apply
Perform a sort operation.
- Write
Invoke action clear
Clears the sorting that is currently on the table. While this doesn't modify the table's ordering, it clears the state of the header buttons.
- Write
Invoke action reapply
Reapplies the current sorting parameters to the table.
- Write
Invoke action add
Create a new table. The range source address determines the worksheet under which the table will be added. If the table can't be added (for example, because the address is invalid, or the table would overlap with another table), an error is generated.
- Write
Create new navigation property to columns for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/itemAt(index={index})/columns
- Write
Create new navigation property to rows for drives
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/itemAt(index={index})/rows
- Write
Update the navigation property sort in drives
PATCH /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/itemAt(index={index})/sort
- Write
Invoke action add
Add a new worksheet to the workbook. The worksheet is added at the end of existing worksheets. If you want to activate the newly added worksheet, call .activate() on it.
- Destructive
Delete navigation property workbook for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook
- Destructive
Delete navigation property application for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/application
- Destructive
Delete navigation property comments for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/comments/{workbookComment-id}
- Destructive
Delete navigation property replies for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/comments/{workbookComment-id}/replies/{workbookCommentReply-id}
- Destructive
Delete navigation property functions for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/functions
- Destructive
Delete navigation property names for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/sort
- Destructive
Delete navigation property operations for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/operations/{workbookOperation-id}
- Destructive
Delete navigation property tables for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}
- Destructive
Delete navigation property columns for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}
- Destructive
Delete navigation property filter for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/sort
- Destructive
Delete navigation property filter for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/itemAt(index={index})/filter
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/sort
- Destructive
Delete navigation property rows for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/sort
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/sort
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/tables/itemAt(index={index})/sort
- Destructive
Delete navigation property worksheets for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}
- Destructive
Delete navigation property charts for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}
- Destructive
Delete navigation property axes for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes
- Destructive
Delete navigation property categoryAxis for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/format
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/format/font
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/format/line
- Destructive
Delete navigation property majorGridlines for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/majorGridlines
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/majorGridlines/format
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/majorGridlines/format/line
- Destructive
Delete navigation property minorGridlines for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/minorGridlines
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/minorGridlines/format
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/minorGridlines/format/line
- Destructive
Delete navigation property title for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/title
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/title/format
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/categoryAxis/title/format/font
- Destructive
Delete navigation property seriesAxis for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/format
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/format/font
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/format/line
- Destructive
Delete navigation property majorGridlines for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/majorGridlines
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/majorGridlines/format
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/majorGridlines/format/line
- Destructive
Delete navigation property minorGridlines for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/minorGridlines
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/minorGridlines/format
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/minorGridlines/format/line
- Destructive
Delete navigation property title for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/title
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/title/format
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/seriesAxis/title/format/font
- Destructive
Delete navigation property valueAxis for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/format
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/format/font
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/format/line
- Destructive
Delete navigation property majorGridlines for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/majorGridlines
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/majorGridlines/format
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/majorGridlines/format/line
- Destructive
Delete navigation property minorGridlines for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/minorGridlines
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/minorGridlines/format
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/minorGridlines/format/line
- Destructive
Delete navigation property title for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/title
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/title/format
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/axes/valueAxis/title/format/font
- Destructive
Delete navigation property dataLabels for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels/format
- Destructive
Delete navigation property fill for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels/format/fill
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/dataLabels/format/font
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/format
- Destructive
Delete navigation property fill for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/format/fill
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/format/font
- Destructive
Delete navigation property legend for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend/format
- Destructive
Delete navigation property fill for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend/format/fill
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/legend/format/font
- Destructive
Delete navigation property series for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/format
- Destructive
Delete navigation property fill for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/format/fill
- Destructive
Delete navigation property line for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/format/line
- Destructive
Delete navigation property points for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/{workbookChartPoint-id}
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/{workbookChartPoint-id}/format
- Destructive
Delete navigation property fill for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/{workbookChartPoint-id}/format/fill
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/{workbookChartSeries-id}/points/itemAt(index={index})/format
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/series/itemAt(index={index})/format
- Destructive
Delete navigation property title for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title/format
- Destructive
Delete navigation property fill for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title/format/fill
- Destructive
Delete navigation property font for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/{workbookChart-id}/title/format/font
- Destructive
Delete navigation property axes for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/axes
- Destructive
Delete navigation property dataLabels for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/dataLabels
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/format
- Destructive
Delete navigation property legend for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/legend
- Destructive
Delete navigation property title for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/title
- Destructive
Delete navigation property axes for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/axes
- Destructive
Delete navigation property dataLabels for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/dataLabels
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/format
- Destructive
Delete navigation property legend for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/legend
- Destructive
Delete navigation property title for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/title
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/sort
- Destructive
Delete navigation property names for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/sort
- Destructive
Delete navigation property pivotTables for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/pivotTables/{workbookPivotTable-id}
- Destructive
Delete navigation property protection for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/protection
- Destructive
Delete navigation property tables for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}
- Destructive
Delete navigation property columns for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}
- Destructive
Delete navigation property filter for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/filter
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/sort
- Destructive
Delete navigation property filter for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/itemAt(index={index})/filter
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/sort
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/sort
- Destructive
Delete navigation property rows for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}
- Destructive
Delete navigation property format for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/format
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/sort
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/sort
- Destructive
Delete navigation property sort for drives
DELETE /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/itemAt(index={index})/sort
Drives.drive.Functions
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/visibleView()
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the column.
- Read
Invoke function headerRowRange
Gets the range object associated with the header row of the column.
- Read
Invoke function range
Gets the range object associated with the entire column.
- Read
Invoke function totalRowRange
Gets the range object associated with the totals row of the column.
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/visibleView()
- Read
Invoke function range
GET /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/itemAt(index={index})/range()
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the table.
- Read
Invoke function headerRowRange
Gets the range object associated with header row of the table.
- Read
Invoke function range
Get the range object associated with the entire table.
- Read
Invoke function totalRowRange
Gets the range object associated with totals row of the table.
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/image()
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/image(width={width},height={height},fittingMode='{fittingMode}')
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/image(width={width},height={height})
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/item(name='{name}')/image(width={width})
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/image()
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/image(width={width},height={height},fittingMode='{fittingMode}')
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/image(width={width},height={height})
- Read
Invoke function image
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/charts/itemAt(index={index})/image(width={width})
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/column(column={column1})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/row(row={row1})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/rowsBelow(count={count})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/rowsBelow(count={count})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/visibleView()
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the column.
- Read
Invoke function headerRowRange
Gets the range object associated with the header row of the column.
- Read
Invoke function range
Gets the range object associated with the entire column.
- Read
Invoke function totalRowRange
Gets the range object associated with the totals row of the column.
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/visibleView()
- Read
Invoke function boundingRect
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/boundingRect(anotherRange='{anotherRange}')
- Read
Invoke function cell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/cell(row={row},column={column})
- Read
Invoke function column
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/column(column={column})
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsAfter()
- Read
Invoke function columnsAfter
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsAfter(count={count})
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsBefore()
- Read
Invoke function columnsBefore
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/columnsBefore(count={count})
- Read
Invoke function entireColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/entireColumn()
- Read
Invoke function entireRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/entireRow()
- Read
Invoke function intersection
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/intersection(anotherRange='{anotherRange}')
- Read
Invoke function lastCell
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/lastCell()
- Read
Invoke function lastColumn
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/lastColumn()
- Read
Invoke function lastRow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/lastRow()
- Read
Invoke function offsetRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})
- Read
Invoke function resizedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})
- Read
Invoke function row
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/row(row={row})
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsAbove()
- Read
Invoke function rowsAbove
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsAbove(count={count})
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsBelow()
- Read
Invoke function rowsBelow
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/rowsBelow(count={count})
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/usedRange()
- Read
Invoke function usedRange
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/usedRange(valuesOnly={valuesOnly})
- Read
Invoke function visibleView
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/visibleView()
- Read
Invoke function range
GET /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/itemAt(index={index})/range()
- Read
Invoke function dataBodyRange
Gets the range object associated with the data body of the table.
- Read
Invoke function headerRowRange
Gets the range object associated with header row of the table.
- Read
Invoke function range
Get the range object associated with the entire table.
- Read
Invoke function totalRowRange
Gets the range object associated with totals row of the table.
Drives.drive.Actions
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/dataBodyRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/headerRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/totalRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/unmerge
- Write
Invoke action clearFilters
Clears all the filters currently applied on the table.
- Write
Invoke action convertToRange
Converts the table into a normal range of cells. All data is preserved.
- Write
Invoke action reapplyFilters
Reapplies all the filters currently on the table.
- Write
Invoke action setData
Resets the source data for the chart.
- Write
Invoke action setPosition
Positions the chart relative to cells on the worksheet.
- Write
Invoke action setData
Resets the source data for the chart.
- Write
Invoke action setPosition
Positions the chart relative to cells on the worksheet.
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/cell(row={row},column={column})/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/range(address='{address}')/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/usedRange(valuesOnly={valuesOnly})/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/names/{workbookNamedItem-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/totalRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/dataBodyRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/headerRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/range()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/totalRowRange()/unmerge
- Write
Invoke action clear
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/clear
- Write
Invoke action delete
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/delete
- Write
Invoke action insert
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/insert
- Write
Invoke action merge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/merge
- Write
Invoke action unmerge
POST /drives/{drive-id}/items/{driveItem-id}/workbook/worksheets/{workbookWorksheet-id}/tables/{workbookTable-id}/rows/{workbookTableRow-id}/range()/unmerge
- Write
Invoke action clearFilters
Clears all the filters currently applied on the table.
- Write
Invoke action convertToRange
Converts the table into a normal range of cells. All data is preserved.
- Write
Invoke action reapplyFilters
Reapplies all the filters currently on the table.
No operations match.
See How connections work for access and permissions, or browse all integrations.
Reference date: October 27, 2026. Excel API docs.