excel-online

What This Skill Does

The excel-online skill enables the OpenClaw AI agent to interact directly with Microsoft Excel workbooks stored in OneDrive or SharePoint. By leveraging the Microsoft Graph API, this skill allows the agent to read, modify, and manage spreadsheet data programmatically. It supports comprehensive operations including listing files, retrieving worksheet structures, reading specific cell ranges, updating cell values, creating new worksheets, generating tables, and executing Excel functions like SUM or AVERAGE. This effectively turns your Excel files into dynamic databases that the AI agent can query and update in real-time, facilitating complex reporting and data-driven automation tasks directly within your workflow.

Installation

To install this skill, use the OpenClaw CLI tool in your terminal:

clawhub install openclaw/skills/skills/mrgoodb/excel-online

Ensure that you have set your MICROSOFT_ACCESS_TOKEN environment variable correctly to grant the agent the necessary permissions to access your OneDrive resources. Refer to the Microsoft Graph documentation if you encounter scope-related authorization errors.

Use Cases

• Automated Reporting: Periodically fetch data from an Excel tracker and summarize key metrics or performance indicators.
• Dynamic Data Entry: Feed AI-processed results directly into a master tracking sheet without manually opening the Excel application.
• Calculation Pipelines: Use the agent to perform advanced Excel formula calculations on structured datasets and append the results back to the source file.
• Inventory Management: Update stock levels or price lists in a shared OneDrive file based on incoming data streams or user requests.

Example Prompts

1. "Open the 'Q3_Sales.xlsx' file and tell me the total sum of the values in the range B2 to B50."
2. "Add a new worksheet called 'Project_Log' to the 'Project_Tracker.xlsx' file and create a table in the range A1:E10 with headers."
3. "Update cells A1 and B1 in the 'Budget' worksheet of my 'Finances.xlsx' file to 'Date' and 'Amount' respectively."

Tips & Limitations

• Token Security: Treat your access token as a sensitive credential. Do not hardcode it in scripts; use environment variables or a secret manager.
• Range Addressing: When reading or writing ranges, ensure you use proper A1-style notation. Invalid range strings will result in API errors.
• Performance: Large Excel workbooks may result in slower response times or API timeouts. It is recommended to perform operations on specific, smaller ranges rather than reading the entire workbook at once.
• Permissions: Ensure the account associated with your token has appropriate 'Files.ReadWrite' permissions granted in the Azure portal for the targeted OneDrive folder.