Microsoft Excel (Advanced)

Advanced automation and integration APIs for Microsoft Excel, enabling programmatic access to spreadsheet data, formulas, charts, and automation capabilities through Microsoft Graph, Office Scripts, JavaScript add-ins, custom functions, OneDrive REST endpoints, and Power Automate connectors.

6 APIs 0 Features

AutomationBusiness IntelligenceData AnalysisOfficeSpreadsheets

APIs

Microsoft Graph Excel API

REST API for reading and writing Excel workbook data through Microsoft Graph.

Office Scripts API

TypeScript-based automation API for Excel on the web and desktop.

Excel JavaScript API

JavaScript API for building Excel add-ins and extensions.

Excel Custom Functions API

API for creating custom functions in Excel using JavaScript.

Excel REST API (OneDrive)

REST API for accessing Excel files stored in OneDrive and SharePoint.

Power Automate Excel Connector

Pre-built connector for automating Excel workflows in Power Automate.

Collections

Microsoft Graph Excel API

OPEN

Pricing Plans

Microsoft Excel Advanced Plans Pricing

3 plans

PLANS

Rate Limits

Microsoft Excel Advanced Rate Limits

5 limits

RATE LIMITS

FinOps

Microsoft Excel Advanced Finops

FINOPS

Resources

Authentication Guide

Sources

opencollection: 1.0.0
info:
  name: Microsoft Graph Excel API
  version: v1.0
request:
  auth:
    type: oauth2
    flow: authorization_code
    authorizationUrl: https://login.microsoftonline.com/common/oauth2/v2.0/authorize
    accessTokenUrl: https://login.microsoftonline.com/common/oauth2/v2.0/token
    credentials:
      clientId: '{{clientId}}'
      clientSecret: '{{clientSecret}}'
items:
- info:
    name: Sessions
    type: folder
  items:
  - info:
      name: Create a workbook session
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/createSession
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      body:
        type: json
        data: '{}'
    docs: Create a workbook session
  - info:
      name: Close a workbook session
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/closeSession
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
    docs: Close a workbook session
- info:
    name: Worksheets
    type: folder
  items:
  - info:
      name: List worksheets in a workbook
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
    docs: List worksheets in a workbook
  - info:
      name: Add a worksheet
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      body:
        type: json
        data: '{}'
    docs: Add a worksheet
  - info:
      name: Get a worksheet
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
    docs: Get a worksheet
  - info:
      name: Update worksheet properties
      type: http
    http:
      method: PATCH
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Update worksheet properties
  - info:
      name: Delete a worksheet
      type: http
    http:
      method: DELETE
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
    docs: Delete a worksheet
- info:
    name: Range
    type: folder
  items:
  - info:
      name: Get a range
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id/range(address=':address')
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
      - name: address
        value: ''
        type: path
    docs: Get a range
  - info:
      name: Update range values
      type: http
    http:
      method: PATCH
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id/range(address=':address')
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
      - name: address
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Update range values
- info:
    name: Tables
    type: folder
  items:
  - info:
      name: List tables on a worksheet
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id/tables
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
    docs: List tables on a worksheet
  - info:
      name: Add a table
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/add
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      body:
        type: json
        data: '{}'
    docs: Add a table
  - info:
      name: Get a table
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
    docs: Get a table
  - info:
      name: Update a table
      type: http
    http:
      method: PATCH
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Update a table
  - info:
      name: Delete a table
      type: http
    http:
      method: DELETE
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
    docs: Delete a table
- info:
    name: TableRows
    type: folder
  items:
  - info:
      name: List table rows
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id/rows
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
    docs: List table rows
  - info:
      name: Add table rows
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id/rows
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Add table rows
- info:
    name: TableColumns
    type: folder
  items:
  - info:
      name: List table columns
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id/columns
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
    docs: List table columns
  - info:
      name: Add a table column
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/tables/:table-id/columns
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: table-id
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Add a table column
- info:
    name: Charts
    type: folder
  items:
  - info:
      name: List charts on a worksheet
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id/charts
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
    docs: List charts on a worksheet
  - info:
      name: Add a chart
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/worksheets/:worksheet-id/charts/add
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: worksheet-id
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Add a chart
- info:
    name: NamedItems
    type: folder
  items:
  - info:
      name: List named items in a workbook
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/names
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
    docs: List named items in a workbook
- info:
    name: Functions
    type: folder
  items:
  - info:
      name: Invoke a workbook function
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:item-id/workbook/functions/:function-name
      headers:
      - name: workbook-session-id
        value: ''
      params:
      - name: item-id
        value: ''
        type: path
        description: DriveItem ID of the .xlsx workbook
      - name: function-name
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Invoke a workbook function
bundled: true