Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| FASTMCP_PORT | No | Port the server listens on when using SSE transport | 8000 |
| EXCEL_FILES_PATH | No | Directory where Excel files are read from and written to when using SSE transport | ./excel_files |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| apply_formula | |
| validate_formula_syntax | Validate Excel formula syntax without applying it. |
| format_range | Apply formatting to a range of cells. |
| read_data_from_excel | |
| write_data_to_excel | |
| create_workbook | Create new Excel workbook. |
| create_worksheet | Create new worksheet in workbook. |
| create_chart | Create chart in worksheet. |
| create_pivot_table | Create pivot table in worksheet. |
| create_table | Creates a native Excel table from a specified range of data. |
| copy_worksheet | Copy worksheet within workbook. |
| delete_worksheet | Delete worksheet from workbook. |
| rename_worksheet | Rename worksheet in workbook. |
| get_workbook_metadata | Get metadata about workbook including sheets, ranges, etc. |
| merge_cells | Merge a range of cells. |
| unmerge_cells | Unmerge a range of cells. |
| copy_range | Copy a range of cells to another location. |
| delete_range | Delete a range of cells and shift remaining cells. |
| validate_excel_range | Validate if a range exists and is properly formatted. |
| get_data_validation_info |