microsoft-excel

What This Skill Does

The Microsoft Excel skill for OpenClaw provides a powerful, secure bridge between your AI agent and the Microsoft Graph API. It enables your agent to programmatically interact with Excel workbooks stored in OneDrive or SharePoint. By leveraging managed OAuth authentication through the Maton gateway, the skill handles the complexities of secure access, allowing your agent to read, write, update, and analyze spreadsheet data without manual token management. Whether you need to retrieve cell values, modify existing tables, calculate complex formulas, or generate data for reports, this skill ensures your AI agent can manipulate your business data efficiently and reliably.

Installation

To integrate this skill into your environment, follow these steps:

1. Ensure you have the OpenClaw CLI installed.
2. Run the command: clawhub install openclaw/skills/skills/byungkyu/microsoft-excel.
3. Register and obtain your API key from maton.ai.
4. Set your key in your local environment variables: export MATON_API_KEY="YOUR_API_KEY".
5. Authenticate your account by managing connections at https://ctrl.maton.ai.

Use Cases

• Automated Data Processing: Have your agent monitor daily sales reports and automatically extract key performance indicators.
• Inventory Management: Update stock levels in real-time within an Excel inventory table based on external triggers or input.
• Collaborative Reporting: Generate summaries and charts from raw data and write them back into a shared project dashboard workbook.
• Data Migration: Programmatically move data from various sources into structured Excel formats for financial analysis.

Example Prompts

1. "Read the table 'Q1_Sales' in workbook 'Financials.xlsx' and summarize the total revenue per region."
2. "Add a new row to the 'Inventory' sheet with values for 'Product_ID': 502, 'Quantity': 25, and 'Location': 'Warehouse_B'."
3. "Open 'Expense_Report.xlsx' and update the cell value in row 12, column D to $450.00."

Tips & Limitations

• Permissions: Ensure the account used for OAuth has the necessary read/write permissions for the specific SharePoint or OneDrive folders.
• Structure: Always ensure table headers are correctly formatted; the API relies on named ranges and standard table structures to perform accurate writes.
• Connection Management: If requests fail, verify your connection status at ctrl.maton.ai to ensure the session token is still valid.
• Throttling: Be mindful of Microsoft Graph API rate limits when performing bulk operations in large workbooks.