Read, write, and analyze data in Microsoft Excel.
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.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-03-06 | A+ | 96 | - | v1 |
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.