Skip to content
Changelog

Report a bug

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 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.

See How connections work for access and permissions, or browse all integrations.

Reference date: October 27, 2026. Excel API docs.