create_table
Creates a native Excel table from a specified range within a worksheet, allowing optional naming and styling for organized data presentation.
Instructions
Creates a native Excel table from a specified range of data.
Args:
sheet_name: Name of worksheet
data_range: Range of data to create table from
session_id: Session ID from open_workbook (preferred)
filepath: Path to Excel file (legacy, deprecated)
table_name: Name for the table (optional)
table_style: Style for the table (optional)
Note: Use session_id for better performance. filepath parameter is deprecated.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sheet_name": "<sheet_name>",
"data_range": "<data_range>"
},
"name": "create_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_name | Yes | ||
| data_range | Yes | ||
| session_id | No | ||
| filepath | No | ||
| table_name | No | ||
| table_style | No | TableStyleMedium9 |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |