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 Worksheets API

Worksheet management within a workbook

Advanced Excel Worksheets 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 Worksheets. 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 4 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 4 schemas 1 GET1 POST

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 Worksheets 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 POST. Each is listed below with its method, path, parameters, and response codes.

Worksheets 2

Worksheet management within a workbook

GET
/me/drive/items/{driveItemId}/workbook/worksheets
Microsoft Excel List Worksheets
listWorksheets 1 param → 200401
POST
/me/drive/items/{driveItemId}/workbook/worksheets
Microsoft Excel Add Worksheet
addWorksheet 1 param body → 201401

Schemas 4

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

Worksheet
object
An Excel worksheet.
4 properties
WorksheetList
object
List of worksheets.
1 property
WorksheetInput
object
Request to add a new worksheet.
1 property
ErrorResponse
object
Microsoft Graph API error response.
1 property

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

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

Other APIs Advanced Excel publishes across the network.

Advanced Excel Charts API
Advanced Excel Ranges API
Advanced Excel Tables API
Advanced Excel Workbooks API