Advanced Excel

Advanced Excel is a subject-matter topic encompassing Microsoft Excel's programmatic capabilities for data analysis, formula execution, workbook management, chart generation, and automation. This topic index covers REST APIs, open data schemas, and developer tools for working with Excel workbooks programmatically, including Microsoft Graph Excel API, open-source spreadsheet libraries, and data interchange formats used in business intelligence and automation workflows.

1 APIs 8 Features

AutomationBusiness IntelligenceData AnalysisData ProcessingExcelMicrosoftSpreadsheets

APIs

Microsoft Graph Excel API

The Microsoft Graph Excel API provides REST access to Excel workbooks stored in OneDrive, SharePoint, or Teams. Supports reading and writing cell values, executing formulas, man...

Collections

Microsoft Graph Excel API

OPEN

Pricing Plans

Advanced Excel Plans Pricing

3 plans

PLANS

Rate Limits

Advanced Excel Rate Limits

5 limits

RATE LIMITS

FinOps

Advanced Excel Finops

FINOPS

Features

Workbook and Worksheet Management

Create, read, update, and delete Excel workbooks and worksheets via REST API calls.

Formula Execution

Execute Excel formulas and retrieve computed values programmatically via the Microsoft Graph API.

Range and Cell Operations

Read and write cell values, apply formatting, and manipulate named ranges and tables.

Chart Generation

Create and configure charts from worksheet data including column, line, pie, and bar chart types.

Table and PivotTable Operations

Create, query, and manipulate Excel tables and pivot tables via API.

Session Management

Manage persistent workbook sessions for transactional multi-step operations on Excel files.

Named Items and Functions

Access named ranges, defined names, and custom functions within Excel workbooks.

Conditional Formatting

Apply and query conditional formatting rules on cell ranges via the REST API.

Use Cases

Automated Reporting

Generate Excel-based financial, operational, or analytical reports programmatically from business data.

Data Import and Export

Read data from Excel workbooks into business applications or write application data into Excel formats.

Spreadsheet Automation

Automate repetitive Excel tasks such as data cleanup, formula recalculation, and sheet formatting.

Business Intelligence Pipelines

Extract and transform Excel data for loading into data warehouses and BI tools.

Financial Modeling

Execute complex financial models stored in Excel and retrieve results via API for application integration.

Form and Survey Data Collection

Use Excel as a data store for forms and survey responses collected via web or mobile applications.

Semantic Vocabularies

Microsoft Graph Excel Api Context

33 classes · 0 properties

GitHubOrganization

GitHubOrganization

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: Worksheets
    type: folder
  items:
  - info:
      name: Microsoft Excel List Worksheets
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
    docs: Retrieve a list of worksheets in an Excel workbook stored in OneDrive.
  - info:
      name: Microsoft Excel Add Worksheet
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      body:
        type: json
        data: '{}'
    docs: Add a new worksheet to an Excel workbook.
- info:
    name: Ranges
    type: folder
  items:
  - info:
      name: Microsoft Excel Get Cell Range Values
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets/:worksheetId/range(address=':address')
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      - name: worksheetId
        value: ''
        type: path
        description: Worksheet ID or name.
      - name: address
        value: ''
        type: path
        description: Cell range address (e.g., A1:D10).
    docs: Retrieve cell values, formulas, and formatting for a specified range in a worksheet.
  - info:
      name: Microsoft Excel Update Cell Range Values
      type: http
    http:
      method: PATCH
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets/:worksheetId/range(address=':address')
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      - name: worksheetId
        value: ''
        type: path
        description: Worksheet ID or name.
      - name: address
        value: ''
        type: path
        description: Cell range address (e.g., A1:D10).
      body:
        type: json
        data: '{}'
    docs: Write values or formulas to a specified cell range in a worksheet.
- info:
    name: Tables
    type: folder
  items:
  - info:
      name: Microsoft Excel List Worksheet Tables
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets/:worksheetId/tables
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      - name: worksheetId
        value: ''
        type: path
        description: Worksheet ID or name.
    docs: List all tables defined in an Excel worksheet.
- info:
    name: Charts
    type: folder
  items:
  - info:
      name: Microsoft Excel List Worksheet Charts
      type: http
    http:
      method: GET
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets/:worksheetId/charts
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      - name: worksheetId
        value: ''
        type: path
        description: Worksheet ID or name.
    docs: List all charts in an Excel worksheet.
  - info:
      name: Microsoft Excel Add Chart to Worksheet
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/worksheets/:worksheetId/charts
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      - name: worksheetId
        value: ''
        type: path
        description: Worksheet ID or name.
      body:
        type: json
        data: '{}'
    docs: Create a new chart in an Excel worksheet from a specified data range.
- info:
    name: Workbooks
    type: folder
  items:
  - info:
      name: Microsoft Excel Create Workbook Session
      type: http
    http:
      method: POST
      url: https://graph.microsoft.com/v1.0/me/drive/items/:driveItemId/workbook/createSession
      params:
      - name: driveItemId
        value: ''
        type: path
        description: OneDrive item ID of the Excel workbook.
      body:
        type: json
        data: '{}'
    docs: Create a persistent workbook session for transactional batch operations on an Excel file.
bundled: true