apply_excel_formatting
Apply conditional formatting rules to Excel sheets by specifying range, type, condition, value, and color. Customize cell appearance based on data conditions.
Instructions
Apply conditional formatting rules to an Excel sheet
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_path": "<file_path>",
"sheet_name": "<sheet_name>",
"rules": "<rules>"
},
"name": "apply_excel_formatting"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rules | Yes | List of formatting rules. Each: {range, type, condition, value, color} | |
| file_path | Yes | Absolute path to the .xlsx file | |
| sheet_name | Yes | Sheet name | |
| output_path | No | Save to different path |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |