Excel
Empower AI assistants with full control over Microsoft Excel's features, including Power Query, DAX, VBA, and worksheets, via native COM automation.
소개
ExcelMcp acts as a Model Context Protocol (MCP) server, enabling AI assistants to orchestrate complex operations directly within Microsoft Excel using native COM automation. It provides unparalleled control over critical Excel components, including Power Query M code, Data Models with DAX measures, VBA macros, Excel Tables, data connections, ranges, and worksheets. This deep integration allows conversational AI to manage and automate sophisticated Excel workflows, facilitating advanced data manipulation, business intelligence, and programmatic control directly within live Excel workbooks. It also includes a robust CLI for direct human automation.
주요 기능
- 0 GitHub stars
- Comprehensive Power Query (M code) management for transformations and data sources
- Detailed range and worksheet manipulation, including values, formulas, formatting, and hyperlinks
- Extensive Excel Table (ListObject) operations including lifecycle, columns, filters, and sorts
- Full Data Model and DAX measure creation, update, and relationship management
- VBA macro listing, viewing, importing, exporting, updating, and execution
사용 사례
- Version control and programmatic management of Excel code artifacts (M code, DAX, VBA)
- Interactive Excel operations and real-time feedback with AI assistance in development environments
- AI-driven Excel development and automation workflows for business intelligence and data tasks
