excel_create_table
Convert a cell range to an Excel table with custom formatting. Define file path, sheet, range, and table name to apply styles such as table style and row stripes.
Instructions
Convert a range to an Excel table with formatting
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": {
"filePath": "<filePath>",
"sheetName": "<sheetName>",
"range": "<range>",
"tableName": "<tableName>"
},
"name": "excel_create_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the Excel file | |
| sheetName | Yes | Name of the sheet | |
| range | Yes | Range to convert (e.g., A1:D10) | |
| tableName | Yes | Name for the table | |
| tableStyle | No | TableStyleMedium2 | |
| showFirstColumn | No | ||
| showLastColumn | No | ||
| showRowStripes | No | ||
| showColumnStripes | No | ||
| createBackup | No |