Metadata-Version: 2.4
Name: mcp-excel
Version: 0.1.2
Summary: MCP server to give client the ability to read Excel files
Project-URL: Homepage, https://github.com/ericjulianto/mcp-excel
Project-URL: Repository, https://github.com/ericjulianto/mcp-excel.git
License-File: LICENSE
Requires-Python: >=3.12
Requires-Dist: mcp[cli]>=1.3.0
Requires-Dist: openpyxl>=3.1.5
Requires-Dist: pandas>=2.2.3
Requires-Dist: py>=1.11.0
Description-Content-Type: text/markdown

# mcp-excel

MCP server to give client the ability to read Excel files

# Usage

For this MCP server to work, add the following configuration to your MCP config file:

```json
{
  "mcpServers": {
    "excel": {
      "command": "uv",
      "args": [
        "run",
        "python",
        "-m",
        "mcp_excel"
      ]
    }
  }
}
```

## Features

- Read Excel files and get their content as pandas DataFrames
- Extract Excel properties including:
  - Data validation rules
  - Dropdown lists
  - Merged cells
  - Hidden rows and columns
- Comprehensive error handling
- Full test coverage

## Requirements

- Python >= 3.12
- pandas >= 2.2.3
- openpyxl >= 3.1.5
- mcp[cli] >= 1.3.0

## Development

1. Clone the repository
2. Install development dependencies:
   ```bash
   pip install -e ".[dev]"
   ```
3. Run tests:
   ```bash
   pytest
   ```

## License

MIT License
