format_range
Apply custom formatting to Excel cell ranges, including font styles, colors, borders, alignment, and number formats. Add conditional formatting, merge cells, or protect ranges to enhance workbook presentation and functionality.
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"
}