Microsoft Excel
Service domainSPREADSHEETS
Arcade Optimized
Arcade.dev LLM tools for Microsoft Excel
9tools
Microsoft Excel toolkit for Arcade.dev lets LLMs operate on Excel workbooks stored in OneDrive for Business via the Microsoft Graph API. It enables creating workbooks, managing worksheets, reading workbook and worksheet metadata, and reading/updating cells and ranges using sparse formats and pagination.
Capabilities
- Manage workbook and worksheet lifecycle (create, add, rename, delete) with session_id support to mitigate Graph propagation delays.
- Inspect workbook metadata and worksheet lists including visibility and positions.
- Read sparse cell data with pagination hints and update single cells or sparse ranges (strings, numbers, booleans, formulas).
- Handle consistency and retry patterns around short propagation windows.
OAuth Provider: microsoft Scopes: Files.Read, Files.ReadWrite, User.Read
Available tools(9)
9 of 9 tools
Operations
Behavior
| Tool name | Description | Secrets | |
|---|---|---|---|
Add a new worksheet to the workbook.
Note: The new worksheet name may not be immediately visible to other
tools due to a brief Graph API propagation delay (up to ~10 s). Pass
the returned ``session_id`` to subsequent calls that reference the new
worksheet to mitigate this. | |||
Create a new Excel workbook (.xlsx) in OneDrive for Business.
Only .xlsx files are supported. OneDrive Consumer (personal accounts) is NOT supported. | |||
Delete a worksheet from the workbook.
Cannot delete the last worksheet in a workbook.
Note: If referencing a recently added or renamed worksheet, pass the
``session_id`` from that operation. A brief Graph API propagation delay
(up to ~10 s) may cause a WorksheetNotFoundError; retry with the
``session_id`` if this occurs. | |||
Get metadata about an Excel workbook including worksheet list.
Returns workbook name, URL, and all worksheets with their names, positions, and visibility. | |||
Read cell values from a worksheet.
Returns data in sparse dict format where data[ROW][COL] has userEnteredValue
and formattedValue for each non-empty cell. Includes pagination hints if more
data exists beyond the requested range.
Note: If referencing a recently added or renamed worksheet, pass the
``session_id`` from that operation. A brief Graph API propagation delay
(up to ~10 s) may cause a WorksheetNotFoundError; retry with the
``session_id`` if this occurs. | |||
Rename an existing worksheet in the workbook.
Note: The new name may not be immediately visible to other tools due
to a brief Graph API propagation delay (up to ~10 s). Pass the returned
``session_id`` to subsequent calls that reference the renamed worksheet
to mitigate this. If referencing a recently added worksheet as the source,
the same delay applies; retry with the ``session_id`` if a
WorksheetNotFoundError occurs. | |||
Update a single cell value in an Excel workbook.
Supports strings, numbers, booleans, and formulas (values starting with '=').
Note: If referencing a recently added or renamed worksheet, pass the
``session_id`` from that operation. A brief Graph API propagation delay
(up to ~10 s) may cause a WorksheetNotFoundError; retry with the
``session_id`` if this occurs. | |||
Update multiple cells in a worksheet using sparse dict format.
Only specified cells are updated; unspecified cells remain unchanged.
The data format is the same as Google Sheets update_cells.
Internally, a single PATCH request is sent covering the bounding box
of all specified cells. Cells within the box that are not in the
input are sent as ``null``, which the Graph API treats as "skip".
Note: If referencing a recently added or renamed worksheet, pass the
``session_id`` from that operation. A brief Graph API propagation delay
(up to ~10 s) may cause a WorksheetNotFoundError; retry with the
``session_id`` if this occurs. | |||
Get information about the current user and their Microsoft Excel environment. |
Get Building
Last updated on