Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Advanced Excel Ranges API

Cell range read/write operations

Advanced Excel Ranges API is one of 5 APIs that Advanced Excel publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 2 JSON Schema definitions.

Tagged areas include Ranges. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, and 2 JSON Schemas.

This API exposes 2 operations across 1 path, and defines 3 schemas. It is described by OpenAPI 3.0.3, at version v1.0.

Requests are made against a single base URL, https://graph.microsoft.com/v1.0.

2 operations 1 paths 3 schemas 1 GET1 PATCH

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.0.3
API Version
v1.0
Base URL
https://graph.microsoft.com/v1.0
Authentication
OAuth 2.0
Terms of Service
Resource Areas
1

Authentication & Security 1

Advanced Excel Ranges API declares 1 security scheme for authenticating requests. It supports OAuth 2.0 (oauth2) using the authorizationCode flow, exposing 2 scopes. By default, every request must be authenticated.

Paths & Operations 2

Across 1 path, the API surfaces 2 operations — 1 GET, 1 PATCH. Each is listed below with its method, path, parameters, and response codes.

Ranges 2

Cell range read/write operations

GET
/me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/range(address='{address}')
Microsoft Excel Get Cell Range Values
getRange 3 params → 200401
PATCH
/me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/range(address='{address}')
Microsoft Excel Update Cell Range Values
updateRange 3 params body → 200401

Schemas 3

The contract defines 3 schemas that model the data the API accepts and returns. The most detailed are Range (3 properties), ErrorResponse (1 property), RangeInput (1 property). Each schema is shown below with its type and property counts.

Range
object
A cell range in a worksheet with values and formulas.
3 properties
RangeInput
object
Request to write values to a range.
1 property
ErrorResponse
object
Microsoft Graph API error response.
1 property

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

advanced-excel-ranges-api-openapi.yml Raw ↑

Other APIs Advanced Excel publishes across the network.

Advanced Excel Charts API
Advanced Excel Tables API
Advanced Excel Workbooks API
Advanced Excel Worksheets API