Advanced Excel · Capability

Microsoft Graph Excel API — Ranges

Microsoft Graph Excel API — Ranges. 2 operations. Lead operation: Microsoft Excel Get Cell Range Values. Self-contained Naftiko capability covering one Advanced Excel business surface.

Run with Naftiko Advanced ExcelRanges

What You Can Do

GET
Getrange — Microsoft Excel Get Cell Range Values
/v1/me/drive/items/{driveitemid}/workbook/worksheets/{worksheetid}/range-address-address
PATCH
Updaterange — Microsoft Excel Update Cell Range Values
/v1/me/drive/items/{driveitemid}/workbook/worksheets/{worksheetid}/range-address-address

MCP Tools

microsoft-excel-get-cell-range

Microsoft Excel Get Cell Range Values

read-only idempotent
microsoft-excel-update-cell-range

Microsoft Excel Update Cell Range Values

idempotent

Capability Spec

microsoft-graph-excel-ranges.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Microsoft Graph Excel API — Ranges
  description: 'Microsoft Graph Excel API — Ranges. 2 operations. Lead operation: Microsoft Excel Get Cell Range Values. Self-contained
    Naftiko capability covering one Advanced Excel business surface.'
  tags:
  - Advanced Excel
  - Ranges
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    ADVANCED_EXCEL_API_KEY: ADVANCED_EXCEL_API_KEY
capability:
  consumes:
  - type: http
    namespace: microsoft-graph-excel-ranges
    baseUri: https://graph.microsoft.com/v1.0
    description: Microsoft Graph Excel API — Ranges business capability. Self-contained, no shared references.
    resources:
    - name: me-drive-items-driveItemId-workbook-worksheets-worksheetId-range(address='{addre
      path: /me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/range(address='{address}')
      operations:
      - name: getrange
        method: GET
        description: Microsoft Excel Get Cell Range Values
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: driveItemId
          in: path
          type: string
          description: OneDrive item ID of the Excel workbook.
          required: true
        - name: worksheetId
          in: path
          type: string
          description: Worksheet ID or name.
          required: true
        - name: address
          in: path
          type: string
          description: Cell range address (e.g., A1:D10).
          required: true
      - name: updaterange
        method: PATCH
        description: Microsoft Excel Update Cell Range Values
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: driveItemId
          in: path
          type: string
          description: OneDrive item ID of the Excel workbook.
          required: true
        - name: worksheetId
          in: path
          type: string
          description: Worksheet ID or name.
          required: true
        - name: address
          in: path
          type: string
          description: Cell range address (e.g., A1:D10).
          required: true
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    authentication:
      type: bearer
      token: '{{env.ADVANCED_EXCEL_API_KEY}}'
  exposes:
  - type: rest
    namespace: microsoft-graph-excel-ranges-rest
    port: 8080
    description: REST adapter for Microsoft Graph Excel API — Ranges. One Spectral-compliant resource per consumed operation,
      prefixed with /v1.
    resources:
    - path: /v1/me/drive/items/{driveitemid}/workbook/worksheets/{worksheetid}/range-address-address
      name: me-drive-items-driveitemid-workbook-worksheets-worksheetid-range-address-addre
      description: REST surface for me-drive-items-driveItemId-workbook-worksheets-worksheetId-range(address='{addre.
      operations:
      - method: GET
        name: getrange
        description: Microsoft Excel Get Cell Range Values
        call: microsoft-graph-excel-ranges.getrange
        with:
          driveItemId: rest.driveItemId
          worksheetId: rest.worksheetId
          address: rest.address
        outputParameters:
        - type: object
          mapping: $.
      - method: PATCH
        name: updaterange
        description: Microsoft Excel Update Cell Range Values
        call: microsoft-graph-excel-ranges.updaterange
        with:
          driveItemId: rest.driveItemId
          worksheetId: rest.worksheetId
          address: rest.address
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: microsoft-graph-excel-ranges-mcp
    port: 9090
    transport: http
    description: MCP adapter for Microsoft Graph Excel API — Ranges. One tool per consumed operation, routed inline through
      this capability's consumes block.
    tools:
    - name: microsoft-excel-get-cell-range
      description: Microsoft Excel Get Cell Range Values
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: microsoft-graph-excel-ranges.getrange
      with:
        driveItemId: tools.driveItemId
        worksheetId: tools.worksheetId
        address: tools.address
      outputParameters:
      - type: object
        mapping: $.
    - name: microsoft-excel-update-cell-range
      description: Microsoft Excel Update Cell Range Values
      hints:
        readOnly: false
        destructive: false
        idempotent: true
      call: microsoft-graph-excel-ranges.updaterange
      with:
        driveItemId: tools.driveItemId
        worksheetId: tools.worksheetId
        address: tools.address
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.