0.1.0 • Published 2 months ago

@shmaxi/excel-mcp-server v0.1.0

Weekly downloads
-
License
MIT
Repository
github
Last release
2 months ago

Excel MCP Server (Node.js)

Excel MCP Server for manipulating Excel files - Node.js implementation with npx support.

Installation

You can run this server using npx without installing:

npx @shmaxi/excel-mcp-server stdio

Or install globally:

npm install -g @shmaxi/excel-mcp-server
excel-mcp-server stdio

Usage

Stdio Transport (Local Integration)

{
  "mcpServers": {
    "excel": {
      "command": "npx",
      "args": ["@shmaxi/excel-mcp-server", "stdio"]
    }
  }
}

SSE Transport (Remote Connections)

FASTMCP_PORT=8000 npx @shmaxi/excel-mcp-server sse

Available Tools

Workbook Operations

  • create_workbook - Create a new Excel workbook
  • get_workbook_metadata - Get metadata about an Excel workbook

Data Operations

  • write_data_to_excel - Write data to a worksheet
  • read_data_from_excel - Read data from a worksheet

Formatting Operations

  • format_range - Apply formatting to a range of cells
  • merge_cells - Merge a range of cells
  • unmerge_cells - Unmerge previously merged cells
  • apply_formula - Apply a formula to a cell

Chart Operations

  • create_chart - Create a chart in the worksheet
  • create_pivot_table - Create a pivot table

Worksheet Operations

  • create_worksheet - Create a new worksheet
  • copy_worksheet - Copy a worksheet
  • delete_worksheet - Delete a worksheet
  • rename_worksheet - Rename a worksheet

Range Operations

  • copy_range - Copy a range of cells
  • delete_range - Delete a range of cells
  • validate_excel_range - Validate if a range reference is valid
  • validate_formula_syntax - Validate Excel formula syntax

Development

# Install dependencies
npm install

# Build
npm run build

# Run in development mode
npm run dev stdio

License

MIT