format_range

format_range

Apply custom formatting to Excel cell ranges, including font styles, colors, borders, alignment, and conditional formatting. Ideal for automating workbook styling in secure corporate environments.

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