create_table
Transform a specified data range into a native Excel table, enabling structured data management, formatting, and advanced analysis within Excel workbooks.
Instructions
Creates a native Excel table from a specified range of data.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data_range | Yes | ||
| filepath | Yes | ||
| sheet_name | Yes | ||
| table_name | No | ||
| table_style | No | TableStyleMedium9 |
Implementation Reference
- src/excel_mcp/server.py:353-377 (handler)MCP tool handler and registration for 'create_table'. Resolves file path, calls the implementation, and handles errors.@mcp.tool() def create_table( filepath: str, sheet_name: str, data_range: str, table_name: Optional[str] = None, table_style: str = "TableStyleMedium9" ) -> str: """Creates a native Excel table from a specified range of data.""" try: full_path = get_excel_path(filepath) result = create_table_impl( filepath=full_path, sheet_name=sheet_name, data_range=data_range, table_name=table_name, table_style=table_style ) return result["message"] except DataError as e: return f"Error: {str(e)}" except Exception as e: logger.error(f"Error creating table: {e}") raise
- src/excel_mcp/tables.py:10-69 (helper)Core helper function that implements the Excel table creation using openpyxl.Table, including style application and validation.def create_excel_table( filepath: str, sheet_name: str, data_range: str, table_name: str | None = None, table_style: str = "TableStyleMedium9" ) -> dict: """Creates a native Excel table for the given data range. Args: filepath: Path to the Excel file. sheet_name: Name of the worksheet. data_range: The cell range for the table (e.g., "A1:D5"). table_name: A unique name for the table. If not provided, a unique name is generated. table_style: The visual style to apply to the table. Returns: A dictionary with a success message and table details. """ try: wb = load_workbook(filepath) if sheet_name not in wb.sheetnames: raise DataError(f"Sheet '{sheet_name}' not found.") ws = wb[sheet_name] # If no table name is provided, generate a unique one if not table_name: table_name = f"Table_{uuid.uuid4().hex[:8]}" # Check if table name already exists if table_name in ws.parent.defined_names: raise DataError(f"Table name '{table_name}' already exists.") # Create the table table = Table(displayName=table_name, ref=data_range) # Apply style style = TableStyleInfo( name=table_style, showFirstColumn=False, showLastColumn=False, showRowStripes=True, showColumnStripes=False ) table.tableStyleInfo = style ws.add_table(table) wb.save(filepath) return { "message": f"Successfully created table '{table_name}' in sheet '{sheet_name}'.", "table_name": table_name, "range": data_range } except Exception as e: logger.error(f"Failed to create table: {e}") raise DataError(str(e))