Reference · built on requestConnectorFiles, documents & spreadsheets

Microsoft Excel

Worksheets, tables, ranges, and named items in Excel workbooks stored in Microsoft 365, through the Graph workbook API.

Request accessPricing ↗

About

Microsoft Excel workbooks stored in OneDrive for Business, a SharePoint site, or a group drive can be read and changed through the workbook resource in Microsoft Graph. The workbook hangs off the file's driveItem, at /me/drive/items/{id}/workbook/, and holds worksheets, tables with rows and columns, ranges addressed like A1:B2, charts, and named items. Only Office Open XML workbooks are supported.

Through Fibric, an operator reads the tables you name, compares them with the system they summarize, and proposes an added row or a changed range. You see the cells before they are written. The receipt for each write names the range, the old values, the reason, and how to undo it.

This is a reference listing. It documents what Fibric would read from Microsoft Excel and what it could propose, based on the vendor's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Worksheets in a workbook through /workbook/worksheets, each with a name, position, and visibility
  • Tables through /workbook/tables and /workbook/worksheets/{id}/tables, with their rows and columns
  • A range by address through range(address='A1:B2'), returning values, text, formulas, numberFormat, and valueTypes
  • Named items through /workbook/names, each with a type and a value such as Range!$A$1:$D$3
  • Charts on a worksheet, including a rendered chart image
  • The result of a workbook function such as vlookup or pmt, evaluated on the server through /workbook/functions

Proposed actions

  • Target capability: propose a table row through POST /workbook/tables/{id}/rows, with the values array shown to you first
  • Target capability: propose a range write through PATCH on range(address=...), with values or numberFormat
  • Target capability: propose a new worksheet or table, or a sort and filter applied to a table

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Post variance rows to the budget workbook

    The operator compares actual hours from your scheduling system with the budget table and proposes a row per department, values shown before the write.

    With Labor Budget, Forecast Variance

  • Reconcile a count sheet with the warehouse

    After a cycle count, the operator reads the count table, matches each line to your inventory system, and proposes a range write to the variance column.

    With Count Variance, Cycle Count Plan

  • Match invoices held in a workbook

    The operator reads the open invoice table, checks each row against receipts and purchase orders, and proposes the match status in a named range.

    With Three-Way Match

Requirements

  • Workbooks in .xlsx or another Office Open XML format; .xls files are not supported
  • Files stored in OneDrive for Business, a SharePoint site, or a group drive; consumer OneDrive is not supported
  • A workbook-session-id header from createSession for any sequence of calls, with persistChanges set as you intend
  • Files.ReadWrite granted to the app for writes
Authentication
A Microsoft Entra application using Microsoft Graph with Files.Read for reads or Files.ReadWrite for writes; every call sends Authorization: Bearer {access-token}.

Limits

  • Excel calls are limited per app to 5000 requests per 10 seconds across all tenants and 1500 per 10 seconds per tenant
  • A persistent session expires after about 5 minutes of inactivity, a non-persistent one after about 7; an expired session returns 404
  • Writes to unbounded ranges such as A:B are not allowed, and ranges above 5M cells return null for some properties
  • Microsoft recommends sequential requests per workbook; concurrent writes cause throttling, timeouts, and merge conflicts

Access and pricing

Reference listing. Fibric builds the connector under a managed deployment when you request it. Your quote covers the build, capabilities, usage, and support.

Request Microsoft Excel ↗

Questions and answers

Which workbooks can the Graph workbook API open?
Office Open XML workbooks stored in OneDrive for Business, a SharePoint site, or a group drive. Workbooks with the .xls extension are not supported, and workbooks in consumer OneDrive are not supported.
What is a workbook session and do I need one?
createSession returns an id you pass in the workbook-session-id header. With persistChanges true, writes are saved; with false, they go to a temporary copy that is discarded when the session expires. The header is optional, but without it the server must locate the file on every call.
How is the Excel API throttled?
Per app: 5000 requests per 10 seconds across all tenants, and 1500 per 10 seconds per tenant. A throttled response often carries Retry-After. Microsoft says the cost of a call varies with the workbook and the request, and advises against parallel writes to one workbook.
Ask about Microsoft Excel

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.

This connector listing is developed, published, and supported by Fibric. It describes integration with Microsoft Excel through published interfaces. Third-party names and logos identify the systems an integration connects to; they are the property of their respective owners, who are not affiliated with Fibric and do not sponsor or endorse this listing. Trademark policy