Excel

How to connect

• Arcade_ListApps

  See the apps the current caller can act on and whether they are connected. Returns each app's id, name, connected state, and (when connected) the account it is connected as. Call this to answer "what apps do I have?" or when the caller's connection state may have changed since the session started.

• MicrosoftExcel_AddWorksheet

  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.

• MicrosoftExcel_AggregateWorksheet

  Summarize a worksheet by grouping rows and computing per-group aggregates in one call. Use this instead of reading and paginating raw rows when you need totals, averages, counts, or min/max broken down by one or more columns (e.g. revenue by region). Columns can be referenced by letter (group_by) or by header name (group_by_headers) — use whichever is more convenient. Groups are returned in first-seen order and capped by ``limit``. Always check each aggregate's ``numeric_count`` field: non-num

• MicrosoftExcel_CreateOrEditWorkbook

  Create a new .xlsx workbook or edit an existing one in OneDrive for Business. Omit `item_id` to create (an empty workbook is created from `filename`, then the operations are applied); provide `item_id` to edit. To create a populated workbook, pass `filename` plus set_values operations; name the target tab via `worksheet` (or reference one consistent sheet name in the operations) and the new workbook's initial sheet is renamed to match. By default, when creating a workbook for a person to read,

• MicrosoftExcel_CreateWorkbook

  Create a new Excel workbook (.xlsx) in OneDrive for Business. Only .xlsx files are supported. OneDrive Consumer (personal accounts) is NOT supported.

• MicrosoftExcel_DeleteWorksheet

  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.

• MicrosoftExcel_GetWorkbookMetadata

  Get a workbook's structure: worksheets, named ranges, and optionally extents and objects. Call this first when exploring an unfamiliar workbook: it surfaces hidden worksheets and workbook-scoped named ranges. Use `include_used_ranges` to also learn where data lives (used ranges, protection state, and worksheet-local named ranges) before reading, and `include_objects` to enumerate tables and charts. Both add a per-worksheet fan-out, so leave them off for a quick worksheet listing.

• MicrosoftExcel_GetWorksheetData

  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.

• MicrosoftExcel_ListWorkbookComments

  List a workbook's comments, or the replies on a specific comment thread. Provide a comment ID to retrieve that thread's replies instead of the top-level comments.

• MicrosoftExcel_ReadWorksheet

  Read a worksheet range with the detail you choose, with guardrails for large sheets. Request `annotations` for formulas, cell types, number formats, or the range's fill/font/borders; `filter_column` + `filter_contains` to keep matching rows; `columns` to project a subset; `export` for csv/tsv. Reads are bounded to the used range and capped by a row limit and cell budget, paginating via `next_range` rather than returning a whole large sheet at once. Set `row_format="records"` (with `has_header=

• MicrosoftExcel_RenameWorksheet

  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.

• MicrosoftExcel_ReplyToWorkbookComment

  Post a plain-text reply to an existing comment thread on a workbook. The reply is appended to the end of the thread.

• MicrosoftExcel_ScanForDataIssues

  Scan a worksheet (or the whole workbook) for data-quality problems as a structured list. Each issue carries a ``severity`` field (``"high"``, ``"medium"``, or ``"low"``) and the list is ordered high → low before any truncation cap is applied, so critical findings are never dropped in favour of lower-priority ones. By default the scan is sheet-scoped (the named worksheet, or the first sheet when ``worksheet`` is omitted). Pass ``worksheet='*'`` for a workbook-wide audit: every sheet is scanned

• MicrosoftExcel_SearchWorkbooks

  Find Excel workbooks in OneDrive by keyword or folder, returning their item_ids. Provide `query` to search the whole drive by name/content, or leave it empty and pass `parent_folder_id` to list one folder; only .xlsx files are returned. Use a returned `item_id` to read, edit, scan, or comment on a workbook you did not create this session.

• MicrosoftExcel_UpdateCell

  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.

• MicrosoftExcel_UpdateRange

  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.

• MicrosoftExcel_UploadWorkbook

  Upload a complete .xlsx file into OneDrive for Business, preserving it byte-for-byte. Use this to store a workbook you already have as a complete file — one the user provided, or one produced elsewhere with formatting, formulas, and charts intact. To build and format a workbook from data, apply formatting operations when creating it rather than uploading bytes. Large files are uploaded via a resumable upload session automatically.

• MicrosoftExcel_WhoAmI

  Get information about the current user and their Microsoft Excel environment.

Related servers