add_table
Creates an Excel table over a specified A1 range, optionally with headers and a style, returning the table name and range for use in live workbooks.
Instructions
Create an Excel table (ListObject) over a range. Returns the table name and range.
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": {
"range": "<range>"
},
"name": "add_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Table name. Auto-generated when omitted. | |
| range | Yes | A1 range address including headers, e.g. "A1:D20". | |
| style | No | Built-in table style name, e.g. "TableStyleMedium2". | |
| sheetName | No | Worksheet name. Defaults to the active worksheet. | |
| hasHeaders | No | True if the first row contains headers. Default true. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. |