Microsoft Excel

Microsoft Excel integration through Microsoft Graph API enables programmatic access to Excel workbooks stored in OneDrive, SharePoint, or Teams. With support for over 300 built-in Excel functions and full CRUD operations on worksheets, tables, charts, and ranges, the API provides powerful data manipulation and analysis capabilities.

This integration helps AI agents read and write data to Excel files, perform calculations using Excel's formula engine, generate reports and charts, and build automated workflows that leverage Excel as both a data storage and computation platform.

Capabilities

• Create, read, update, and delete worksheets, tables, ranges, and charts
• Access over 300 Excel worksheet functions for calculations and complex business logic
• Read and write cell data with full support for formatting and formulas
• Create and manage named items and references
• Generate charts and reports from workbook data
• Sort and filter table data, apply conditional formatting
• Session-based operations with persistent or non-persistent mode
• Support for Office Open XML format (.xlsx) workbooks

Resources

• Microsoft Graph Excel API Overview
• Excel API Reference
• Write Data to Excel Workbook
• Best Practices