# Excel Edit Server
A Model Context Protocol (MCP) server that provides Excel file editing and analysis capabilities for Large Language Models (LLMs).
## Features
- **Excel File Reading**: Extract and analyze Excel file structure including formulas, merged cells, and data validation
- **Automatic Formatting**: Beautify Excel files with optimized row heights and column widths
- **Formula Analysis**: Detect and report formulas used in worksheets
- **Merged Cell Handling**: Intelligent processing of merged cells with proper height calculation
- **Data Validation Support**: Read and analyze data validation rules
- **Conditional Formatting**: Extract conditional formatting information
- **Text Processing**: Remove citation markers and format text content
## Tools Provided
- `excel_read`: Read and extract the structure of Excel files, including formulas, merged cells, and formatting
- `excel_modify`: Beautify Excel files by optimizing row heights and column widths based on content
## Excel Analysis Features
### Data Structure Analysis
- Complete worksheet structure extraction
- Cell values and formulas detection
- Merged cell range identification
- Data validation rules analysis
### Formatting Information
- Conditional formatting rules extraction
- Filter and sort state detection
- Cell styling and alignment analysis
- Font and formatting properties
### Content Processing
- Automatic text wrapping calculation
- Multi-language text width estimation (Chinese/English)
- Citation marker removal (【†】, [†] patterns)
- Row height optimization based on content
## Configuration Options
- `--workspace-path`: Set the workspace directory (default: ./workspace)
## Server Configuration
To use this server with MCP clients, add the following configuration to your MCP settings:
For development or when using `uv`:
```json
{
"mcpServers": {
"excel-edit-server": {
"command": "uv",
"args": ["--directory", "directory_of_excel-edit-server", "run", "excel-edit-server", "--workspace-path", "/path/to/your/workspace"],
"env": {}
}
}
}
```
## Usage Examples
### Reading Excel File Structure
```python
# Read Excel file and extract structure
content = await excel_read("/path/to/spreadsheet.xlsx")
# Returns markdown-formatted structure with tables, formulas, and formatting info
```
### Beautifying Excel Files
```python
# Optimize row heights and column widths
await excel_modify("/path/to/spreadsheet.xlsx")
# File is automatically saved with improved formatting
```
## Advanced Features
### Intelligent Row Height Calculation
- Considers font size and text content
- Handles wrapped text and multi-line content
- Processes merged cells with vertical spanning
- Supports Chinese and English character width estimation
### Formula Processing
- Extracts all formulas from worksheets
- Reports formula locations and expressions
- Handles complex formula structures
### Data Validation Analysis
- Reads validation rules and constraints
- Extracts error messages and prompts
- Reports validation ranges and types
## Safety Features
- **File Validation**: Checks for file existence before operations
- **Error Handling**: Comprehensive error reporting with detailed messages
- **Backup Safety**: Non-destructive reading operations
- **Format Preservation**: Maintains original Excel formatting while optimizing layout
## Supported Excel Features
- Multiple worksheets
- Merged cells (horizontal and vertical)
- Formulas and calculations
- Data validation rules
- Conditional formatting
- Auto filters and sorting
- Pivot tables (detection)
- Cell styling and fonts
## License
MIT License - see LICENSE file for details.
Raw data
{
"_id": null,
"home_page": null,
"name": "iflow-mcp_excel-edit-server",
"maintainer": null,
"docs_url": null,
"requires_python": "==3.12.7",
"maintainer_email": null,
"keywords": "automation, excel, llm, mcp",
"author": "iflow team",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/c4/6a/99fe6ecaafa692d417c9c66bb8703e2e970b8fecaa1cdffc3049d81f337e/iflow_mcp_excel_edit_server-0.1.2.tar.gz",
"platform": null,
"description": "# Excel Edit Server\n\nA Model Context Protocol (MCP) server that provides Excel file editing and analysis capabilities for Large Language Models (LLMs).\n\n## Features\n\n- **Excel File Reading**: Extract and analyze Excel file structure including formulas, merged cells, and data validation\n- **Automatic Formatting**: Beautify Excel files with optimized row heights and column widths\n- **Formula Analysis**: Detect and report formulas used in worksheets\n- **Merged Cell Handling**: Intelligent processing of merged cells with proper height calculation\n- **Data Validation Support**: Read and analyze data validation rules\n- **Conditional Formatting**: Extract conditional formatting information\n- **Text Processing**: Remove citation markers and format text content\n\n## Tools Provided\n\n- `excel_read`: Read and extract the structure of Excel files, including formulas, merged cells, and formatting\n- `excel_modify`: Beautify Excel files by optimizing row heights and column widths based on content\n\n## Excel Analysis Features\n\n### Data Structure Analysis\n- Complete worksheet structure extraction\n- Cell values and formulas detection\n- Merged cell range identification\n- Data validation rules analysis\n\n### Formatting Information\n- Conditional formatting rules extraction\n- Filter and sort state detection\n- Cell styling and alignment analysis\n- Font and formatting properties\n\n### Content Processing\n- Automatic text wrapping calculation\n- Multi-language text width estimation (Chinese/English)\n- Citation marker removal (\u3010\u2020\u3011, [\u2020] patterns)\n- Row height optimization based on content\n\n## Configuration Options\n\n- `--workspace-path`: Set the workspace directory (default: ./workspace)\n\n## Server Configuration\n\nTo use this server with MCP clients, add the following configuration to your MCP settings:\n\nFor development or when using `uv`:\n\n```json\n{\n \"mcpServers\": {\n \"excel-edit-server\": {\n \"command\": \"uv\",\n \"args\": [\"--directory\", \"directory_of_excel-edit-server\", \"run\", \"excel-edit-server\", \"--workspace-path\", \"/path/to/your/workspace\"],\n \"env\": {}\n }\n }\n}\n```\n\n## Usage Examples\n\n### Reading Excel File Structure\n```python\n# Read Excel file and extract structure\ncontent = await excel_read(\"/path/to/spreadsheet.xlsx\")\n# Returns markdown-formatted structure with tables, formulas, and formatting info\n```\n\n### Beautifying Excel Files\n```python\n# Optimize row heights and column widths\nawait excel_modify(\"/path/to/spreadsheet.xlsx\")\n# File is automatically saved with improved formatting\n```\n\n## Advanced Features\n\n### Intelligent Row Height Calculation\n- Considers font size and text content\n- Handles wrapped text and multi-line content\n- Processes merged cells with vertical spanning\n- Supports Chinese and English character width estimation\n\n### Formula Processing\n- Extracts all formulas from worksheets\n- Reports formula locations and expressions\n- Handles complex formula structures\n\n### Data Validation Analysis\n- Reads validation rules and constraints\n- Extracts error messages and prompts\n- Reports validation ranges and types\n\n## Safety Features\n\n- **File Validation**: Checks for file existence before operations\n- **Error Handling**: Comprehensive error reporting with detailed messages\n- **Backup Safety**: Non-destructive reading operations\n- **Format Preservation**: Maintains original Excel formatting while optimizing layout\n\n## Supported Excel Features\n\n- Multiple worksheets\n- Merged cells (horizontal and vertical)\n- Formulas and calculations\n- Data validation rules\n- Conditional formatting\n- Auto filters and sorting\n- Pivot tables (detection)\n- Cell styling and fonts\n\n## License\n\nMIT License - see LICENSE file for details.",
"bugtrack_url": null,
"license": "MIT",
"summary": "A Model Context Protocol server providing excel edit capability",
"version": "0.1.2",
"project_urls": null,
"split_keywords": [
"automation",
" excel",
" llm",
" mcp"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "7b088ef8846ef899e91ec6c03bfa74251b776320157067504c7c3ac0782308b7",
"md5": "1ecfcd303d41fd9fe38c2782ee9e2ab2",
"sha256": "0edab99695fbb151e2001130ea3660339c688b1a27b869a95edb01e21673331a"
},
"downloads": -1,
"filename": "iflow_mcp_excel_edit_server-0.1.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "1ecfcd303d41fd9fe38c2782ee9e2ab2",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "==3.12.7",
"size": 277804,
"upload_time": "2025-09-01T09:33:02",
"upload_time_iso_8601": "2025-09-01T09:33:02.857219Z",
"url": "https://files.pythonhosted.org/packages/7b/08/8ef8846ef899e91ec6c03bfa74251b776320157067504c7c3ac0782308b7/iflow_mcp_excel_edit_server-0.1.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "c46a99fe6ecaafa692d417c9c66bb8703e2e970b8fecaa1cdffc3049d81f337e",
"md5": "f7a48590343ee96b7f0bf4edd5d3ac3c",
"sha256": "e779ff30279f4a9597251974ba8be538d5c1717745ae27db4ae6b9b8c412e5f4"
},
"downloads": -1,
"filename": "iflow_mcp_excel_edit_server-0.1.2.tar.gz",
"has_sig": false,
"md5_digest": "f7a48590343ee96b7f0bf4edd5d3ac3c",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "==3.12.7",
"size": 274641,
"upload_time": "2025-09-01T09:33:04",
"upload_time_iso_8601": "2025-09-01T09:33:04.350287Z",
"url": "https://files.pythonhosted.org/packages/c4/6a/99fe6ecaafa692d417c9c66bb8703e2e970b8fecaa1cdffc3049d81f337e/iflow_mcp_excel_edit_server-0.1.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-09-01 09:33:04",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "iflow-mcp_excel-edit-server"
}
JSON