jenstangen1/pptx-xlsx-mcp

This repository contains Model Context Protocol (MCP) servers for interacting with Microsoft Office applications through AI assistance. Currently supported applications:
PowerPoint: Create and manipulate presentations
Excel: Interact with workbooks and spreadsheets
Both servers use pywin32 for COM automation, allowing direct interaction with running Office applications.
## Prerequisites
Windows operating system
Microsoft Office installed (PowerPoint and/or Excel)
Python 3.7+
pywin32 package
## Installation
1. Clone the repository:
bash
git clone https://github.com/jenstangen1/mcp-pptx.git
cd mcp-pptx
2. Install dependencies using uv:
bash
uv pip install pywin32
3. Run the pywin32 post-install script with administrator privileges:
bash
python C:\path\to\your\env\Scripts\pywin32postinstall.py -install
## Setting up with Claude
To integrate these MCP servers with Claude, add the following configuration to your Claude Desktop app settings:
json
"mcpServers": {
"powerpointmcpwin32": {
"command": "uv",
"args": [
"run",
"mcppowerpointserverwin32.py"
],
"cwd": "C:\\path\\to\\your\\workspace"
},
"excelmcpwin32": {
"command": "uv",
"args": [
"run",
"mcpexcelserverwin32.py"
],
"cwd": "C:\\path\\to\\your\\workspace"
Note: Replace C:\\path\\to\\your\\workspace with your actual workspace path.
# PowerPoint MCP Server
The PowerPoint server provides a comprehensive API for AI models to interact with PowerPoint presentations, supporting advanced formatting, financial charts, and data integration.
## Features
### Presentation Management
Create and modify PowerPoint presentations
Add, delete, and modify slides
Save and load presentations from workspace
Template management system
### Element Operations
Fine-grained control over slide elements (text, shapes, images, charts)
Advanced shape creation and styling
Element positioning and grouping
Connector lines between shapes
### Financial Integration
Create financial charts (line, bar, column, pie, waterfall, etc.)
Generate comparison tables
Support for various financial metrics:
Revenue
EBITDA
Profit
Assets
Equity
Growth rates
Margins
Currently uses dummy data, with plans to integrate Proff API for Norwegian company data
Adaptable to other financial data providers through API customization
### Styling and Formatting
Rich text formatting
Shape styling (fills, gradients, outlines)
Chart customization
Background colors and effects
Note: You may need to modify the directory path to match your installation location.
## Available MCP Tools
### Presentation Management
listpresentations: List all PowerPoint files in the workspace
uploadpresentation: Upload a new presentation to the workspace
savepresentation: Save the current presentation
### Slide Operations
addslide: Add a new slide to the presentation
deleteslide: Delete a slide from the presentation
getslidecount: Get the total number of slides in the presentation
analyzeslide: Analyze the content of a slide
setbackgroundcolor: Set the background color of a slide
### Element Operations
addtext: Add text to a slide
addshape: Add a shape to a slide
editelement: Edit an element's properties
styleelement: Apply styling to an element
connectshapes: Connect two shapes with a connector