# Microsoft Excel Drives.drive.Functions API

**Canonical:** https://apis.io/apis/microsoft-excel/microsoft-excel-drives-drive-functions-api/  
**Provider:** Microsoft Excel — https://apis.io/providers/microsoft-excel/  
**Base URL:** https://graph.microsoft.com/v1.0  
**Documentation:** https://learn.microsoft.com/en-us/office/dev/add-ins/reference/overview/excel-add-ins-reference-overview

Microsoft Excel Drives.drive.Functions API is one of 14 APIs that [Microsoft Excel](https://apis.io/providers/microsoft-excel/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. This API exposes 6 JSON Schema definitions. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and 6 JSON Schemas.

The drives.drive.Functions API from Microsoft Excel — 596 operation(s) for drives.drive.functions.

## Operations (60 of 596)

| Method | Path | Summary |
|---|---|---|
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/boundingRect(anotherRange='{anotherRange}')` | Invoke function boundingRect |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/cell(row={row},column={column})` | Invoke function cell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/column(column={column})` | Invoke function column |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsAfter()` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsAfter(count={count})` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsBefore()` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsBefore(count={count})` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/entireColumn()` | Invoke function entireColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/entireRow()` | Invoke function entireRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/intersection(anotherRange='{anotherRange}')` | Invoke function intersection |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastCell()` | Invoke function lastCell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastColumn()` | Invoke function lastColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastRow()` | Invoke function lastRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})` | Invoke function offsetRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})` | Invoke function resizedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/row(row={row})` | Invoke function row |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsAbove()` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsAbove(count={count})` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsBelow()` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsBelow(count={count})` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/usedRange()` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/usedRange(valuesOnly={valuesOnly})` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/visibleView()` | Invoke function visibleView |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/boundingRect(anotherRange='{anotherRange}')` | Invoke function boundingRect |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/cell(row={row},column={column})` | Invoke function cell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/column(column={column})` | Invoke function column |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter()` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter(count={count})` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore()` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore(count={count})` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireColumn()` | Invoke function entireColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireRow()` | Invoke function entireRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/intersection(anotherRange='{anotherRange}')` | Invoke function intersection |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastCell()` | Invoke function lastCell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastColumn()` | Invoke function lastColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastRow()` | Invoke function lastRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})` | Invoke function offsetRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})` | Invoke function resizedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/row(row={row})` | Invoke function row |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove()` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove(count={count})` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow()` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow(count={count})` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange()` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange(valuesOnly={valuesOnly})` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/visibleView()` | Invoke function visibleView |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/boundingRect(anotherRange='{anotherRange}')` | Invoke function boundingRect |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/cell(row={row},column={column})` | Invoke function cell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/column(column={column})` | Invoke function column |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter()` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter(count={count})` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore()` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore(count={count})` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireColumn()` | Invoke function entireColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireRow()` | Invoke function entireRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/intersection(anotherRange='{anotherRange}')` | Invoke function intersection |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastCell()` | Invoke function lastCell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastColumn()` | Invoke function lastColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastRow()` | Invoke function lastRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})` | Invoke function offsetRange |

…and 536 more operations. The page lists the first 250; the full set of 596 is in the OpenAPI linked below.

## Machine-readable artifacts (8)

- **OpenAPI** — https://artifacts.apis.io/microsoft-excel/openapi/microsoft-excel-drives-drive-functions-api-openapi.yml
- **Documentation** — https://learn.microsoft.com/en-us/graph/api/resources/excel
- **JSONSchema** — https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-range-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-chart-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-table-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-range-format-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-chart-axis-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-range-view-schema.json

## Other Microsoft Excel APIs (12)

- [Excel JavaScript API](https://apis.io/apis/microsoft-excel/excel-javascript-api/)
- [Office Scripts API](https://apis.io/apis/microsoft-excel/office-scripts-api/)
- [Microsoft Excel Charts API](https://apis.io/apis/microsoft-excel/microsoft-excel-charts-api/)
- [Microsoft Excel Functions API](https://apis.io/apis/microsoft-excel/microsoft-excel-functions-api/)
- [Microsoft Excel Named Items API](https://apis.io/apis/microsoft-excel/microsoft-excel-named-items-api/)
- [Microsoft Excel Ranges API](https://apis.io/apis/microsoft-excel/microsoft-excel-ranges-api/)
- [Microsoft Excel Sessions API](https://apis.io/apis/microsoft-excel/microsoft-excel-sessions-api/)
- [Microsoft Excel Table Columns API](https://apis.io/apis/microsoft-excel/microsoft-excel-table-columns-api/)
- [Microsoft Excel Table Rows API](https://apis.io/apis/microsoft-excel/microsoft-excel-table-rows-api/)
- [Microsoft Excel Tables API](https://apis.io/apis/microsoft-excel/microsoft-excel-tables-api/)
- [Microsoft Excel Worksheets API](https://apis.io/apis/microsoft-excel/microsoft-excel-worksheets-api/)
- [Microsoft Excel Drives.drive.Actions API](https://apis.io/apis/microsoft-excel/microsoft-excel-drives-drive-actions-api/)

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/microsoft-excel/microsoft-excel-drives-drive-functions-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/microsoft-excel/.