set_format
Apply bold, italic, font color, size, wrap, alignment, and number formats to one or more contiguous Excel ranges, with font changes verified by reading cells back.
Instructions
Format one or more contiguous ranges: bold, italic, fontColor (#RRGGBB), fontSize, wrapText, horizontalAlignment (General/Left/Center/Right/Justify), numberFormat (e.g. "yyyy-mm-dd", "0.00", "@" for text). Font changes are read back and verified. Fill colors: use set_fill.
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": {
"file": "<file>",
"sheet": "<sheet>",
"ranges": "<ranges>"
},
"name": "set_format"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| file | Yes | Workbook: SharePoint URL, an alias from ~/.graph-excel/workbooks.json, or "driveId:itemId" | |
| send | No | false (default) = dry run: shows what would change. true = write — only after the user approved (or a standing rule allows it) | |
| sheet | Yes | Worksheet name exactly as listed by resolve | |
| italic | No | ||
| ranges | Yes | ||
| fontSize | No | ||
| wrapText | No | ||
| fontColor | No | ||
| numberFormat | No | ||
| horizontalAlignment | No |