write_data_to_excel

Write structured data to an Excel worksheet with specified file path, sheet name, and starting cell. Supports direct data insertion without verification for efficient worksheet updates.

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