# Microsoft Excel

SecureBarndoor Managed Microsoft 365

**Summary:** Access and update Excel Online workbooks, worksheets, and ranges in OneDrive via Microsoft Graph.

**How Teams Use It:** The Barndoor-managed Microsoft Excel MCP server enables agents to read and update worksheet data, manage workbooks and tabs in OneDrive, and automate spreadsheet workflows via Microsoft Graph.

## Tools

| Tool Name                   | Tool Description                                          | Tool Type |
|-----------------------------|----------------------------------------------------------|-----------|
| add_workbook_worksheet      | Add a new worksheet tab to an Excel workbook.           | create    |
| create_child_item           | Create a child folder under a parent OneDrive folder.   | create    |
| delete_drive_item           | Delete a OneDrive file or folder by ID.                 | delete    |
| get_drive_item              | Retrieve a OneDrive item by drive and item ID.          | read      |
| get_drive_root              | Retrieve root folder metadata for a Microsoft Graph drive. | read   |
| get_my_drive                | Retrieve the signed-in user's default OneDrive metadata. | read      |
| get_workbook_worksheet      | Retrieve worksheet details by worksheet ID or name.     | read      |
| get_worksheet_range         | Retrieve cell values from an A1-style worksheet range.  | read      |
| get_worksheet_used_range    | Retrieve the used range for a worksheet.                | read      |
| list_item_children          | List child files and folders under a parent OneDrive folder. | read  |
| list_workbook_worksheets    | List worksheets in an Excel workbook stored in OneDrive. | read      |
| update_worksheet_range      | Update values or formulas in a worksheet range.         | update    |