write_data_to_excel

Transfer structured data directly to an Excel worksheet. Specify file path, sheet name, and data as a list of rows; optionally define a start cell for precise placement.

Instructions

Write data to Excel worksheet.
Excel formula will write to cell without any verification.

PARAMETERS:  
filepath: Path to Excel file
sheet_name: Name of worksheet to write to
data: List of lists containing data to write to the worksheet, sublists are assumed to be rows
start_cell: Cell to start writing to (optional, auto-finds appropriate location)

Input Schema

Name	Required	Description	Default
`data`	Yes
`filepath`	Yes
`sheet_name`	Yes
`start_cell`	No

Input Schema (JSON Schema)

{
  "properties": {
    "data": {
      "items": {
        "items": {},
        "type": "array"
      },
      "title": "Data",
      "type": "array"
    },
    "filepath": {
      "title": "Filepath",
      "type": "string"
    },
    "sheet_name": {
      "title": "Sheet Name",
      "type": "string"
    },
    "start_cell": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Start Cell"
    }
  },
  "required": [
    "filepath",
    "sheet_name",
    "data"
  ],
  "title": "write_data_to_excelArguments",
  "type": "object"
}

xlwings Excel MCP Server

write_data_to_excel

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from xlwings Excel MCP Server

Related Tools

MCP directory API