excel-mcp-server

excel-mcp-server

0
research_and_datavisualization

The project is designed to offer visualization capabilities for Excel data using an MCP server. It allows the generation of interactive charts, including bar, line, and pie charts, through an interface that supports remote chart generation.

Excel-MCP Server Visualization Project

This project provides visualization capabilities for Excel data through an MCP server interface, generating interactive charts using Pyecharts.

Features

  • Generate bar, line, and pie charts from Excel data
  • Customizable chart templates
  • MCP server integration for remote chart generation
  • Metadata handling for data formatting

Installation

  1. Clone this repository
  2. Install dependencies: 
    pip install -r requirements.txt

Usage

Run the server:

python server.py

Chart Generation

Available chart types:

  • Bar charts (/generate/bar)
  • Line charts (/generate/line)
  • Pie charts (/generate/pie)

Each endpoint accepts Excel data and returns an interactive HTML chart.

Configuration

Edit config.py to customize:

  • Server port
  • Default chart styles
  • Template paths

Dependencies

  • Python 3.8+
  • Pyecharts
  • Flask
  • Pandas
  • Openpyxl