Excel

List columns in a table using Microsoft Graph API.

Tool to search OneDrive drive items by query to discover Excel workbook IDs. Use when you need to find Excel files by name before performing workbook operations.

Tool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis.

Tool to retrieve the data labels object of a chart. Use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.

Tool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting.

Get a range from a worksheet using Microsoft Graph API.

Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.

Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API.

Tool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.

Tool to retrieve the properties and relationships of a workbook. Use when you need to inspect comments, names, tables, or worksheets.

Create a new table in a worksheet using the Microsoft Graph API.

Tool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles.

Create a session for an Excel workbook using Microsoft Graph API.

Add a chart to a worksheet using Microsoft Graph API.

Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.

Add a column to a table using Microsoft Graph API.

Add a row to a table using Microsoft Graph API.

Add a new worksheet to an Excel workbook using Microsoft Graph API.

Tool to insert a new cell range into a worksheet, shifting existing cells down or right. Use when you need to create space for new content without overwriting.

Apply a filter to a table column using Microsoft Graph API.

Apply a sort to a table using Microsoft Graph API.

Tool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive.

Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching.

Merge cells in a worksheet range using Microsoft Graph API.

Tool to protect a worksheet using optional protection options. Use when you need to prevent editing certain parts of a sheet before sharing. Example: "Protect 'Sheet1' to lock formatting and sorting."

Sort a range in a worksheet using Microsoft Graph API.

Update a chart in a worksheet using Microsoft Graph API.

Tool to update formatting or position of a chart legend. Use when adjusting legend settings after confirming chart and worksheet exist.

Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.

Clear a filter from a table column using Microsoft Graph API.

Tool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. Note: The Microsoft Graph closeSession API is idempotent - it returns 204 for both active and already-closed sessions. This action validates the session first and returns an error for invalid or already-closed sessions to provide clearer user feedback. The validation uses refreshSession which is the only API endpoint that can detect closed sessions.

Convert a table to a range using Microsoft Graph API.

Delete a column from a table using Microsoft Graph API.

Delete a row from a table using Microsoft Graph API.

Tool to delete a worksheet from the workbook. Use when cleaning up unused or temporary sheets after verifying no dependencies exist. Example: "Delete 'Sheet2' after review."