format_range

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"
}

xlwings Excel MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from xlwings Excel MCP Server

Related Tools

MCP directory API