spire-xls-mcp-server

eiceblue/spire-xls-mcp-server

3.3

If you are the rightful owner of spire-xls-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Spire.XLS MCP Server is a robust solution that empowers AI agents to work with Excel files using the Model Context Protocol (MCP).

Spire.XLS MCP Server is a powerful tool designed to facilitate seamless interaction with Excel files through AI agents, without the need for Microsoft Office installation. It leverages the Model Context Protocol (MCP) to enable AI-driven operations such as creating, reading, editing, and converting Excel workbooks. This server is particularly beneficial for developers and AI enthusiasts who require a reliable and efficient way to manipulate Excel data programmatically. With its comprehensive set of features, Spire.XLS MCP Server supports a wide range of Excel operations, from basic data processing to advanced data analysis and visualization. It is built with Python, making it accessible and easy to integrate into various AI development environments. The server also supports multiple transport protocols, including Server-Sent Events (SSE), ensuring flexibility in deployment and integration.

Features

  • Convert Excel to various formats such as PDF, HTML, CSV, image, and XML with high fidelity.
  • Create, modify, and manage Excel workbooks and worksheets.
  • Read and write data, apply formulas, and perform data analysis.
  • Add charts and pivot tables for data visualization and summarization.
  • Manage worksheet properties like renaming, moving, hiding, and freezing panes.

Usages

usage with Cursor IDE

{
  "mcpServers": {
    "excel": {
      "url": "http://localhost:8000/sse",
      "env": {
        "EXCEL_FILES_PATH": "/path/to/excel/files"
      }
    }
  }
}

Tools

  1. Basic Operations

    Create, read, write, and delete Excel worksheets or workbooks.

  2. Data Processing

    Read and write cell data, apply formulas, sort and filter.

  3. Formatting

    Apply styles, merge cells, set fonts and colors.

  4. Advanced Features

    Create charts, pivot tables, and apply conditional formatting.

  5. Conversion

    Convert Excel to PDF, HTML, CSV, image, XML, and more.