format_range
Apply custom formatting to a specified range of cells in Excel, including font styles, colors, borders, alignment, and advanced options like conditional formatting and cell protection.
Instructions
Apply formatting to a range of cells.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alignment | No | ||
| bg_color | No | ||
| bold | No | ||
| border_color | No | ||
| border_style | No | ||
| conditional_format | No | ||
| end_cell | No | ||
| filepath | Yes | ||
| font_color | No | ||
| font_size | No | ||
| italic | No | ||
| merge_cells | No | ||
| number_format | No | ||
| protection | No | ||
| sheet_name | Yes | ||
| start_cell | Yes | ||
| underline | No | ||
| wrap_text | No |
Input Schema (JSON Schema)
{
"properties": {
"alignment": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Alignment"
},
"bg_color": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Bg Color"
},
"bold": {
"default": false,
"title": "Bold",
"type": "boolean"
},
"border_color": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Border Color"
},
"border_style": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Border Style"
},
"conditional_format": {
"anyOf": [
{
"additionalProperties": true,
"type": "object"
},
{
"type": "null"
}
],
"default": null,
"title": "Conditional Format"
},
"end_cell": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "End Cell"
},
"filepath": {
"title": "Filepath",
"type": "string"
},
"font_color": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Font Color"
},
"font_size": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"title": "Font Size"
},
"italic": {
"default": false,
"title": "Italic",
"type": "boolean"
},
"merge_cells": {
"default": false,
"title": "Merge Cells",
"type": "boolean"
},
"number_format": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Number Format"
},
"protection": {
"anyOf": [
{
"additionalProperties": true,
"type": "object"
},
{
"type": "null"
}
],
"default": null,
"title": "Protection"
},
"sheet_name": {
"title": "Sheet Name",
"type": "string"
},
"start_cell": {
"title": "Start Cell",
"type": "string"
},
"underline": {
"default": false,
"title": "Underline",
"type": "boolean"
},
"wrap_text": {
"default": false,
"title": "Wrap Text",
"type": "boolean"
}
},
"required": [
"filepath",
"sheet_name",
"start_cell"
],
"title": "format_rangeArguments",
"type": "object"
}