create_table

Convert a specified data range into a native Excel table with customizable styles using the 'create_table' tool, streamlining workbook organization and formatting in secure corporate environments.

Instructions

Creates a native Excel table from a specified range of data.

Input Schema

Name	Required	Default
`data_range`	Yes
`filepath`	Yes
`sheet_name`	Yes
`table_name`	No
`table_style`	No	TableStyleMedium9

Input Schema (JSON Schema)

{
  "properties": {
    "data_range": {
      "title": "Data Range",
      "type": "string"
    },
    "filepath": {
      "title": "Filepath",
      "type": "string"
    },
    "sheet_name": {
      "title": "Sheet Name",
      "type": "string"
    },
    "table_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table Name"
    },
    "table_style": {
      "default": "TableStyleMedium9",
      "title": "Table Style",
      "type": "string"
    }
  },
  "required": [
    "filepath",
    "sheet_name",
    "data_range"
  ],
  "title": "create_tableArguments",
  "type": "object"
}

xlwings Excel MCP Server

create_table

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from xlwings Excel MCP Server

Related Tools

MCP directory API