excel_write_to_sheet

Write data or formulas to specified ranges in an Excel sheet. Supports creating new sheets or updating existing ones. Ideal for automating data entry in Excel files.

Instructions

Write values to the Excel sheet

Input Schema

Name	Required	Description
`fileAbsolutePath`	Yes	Absolute path to the Excel file
`newSheet`	Yes	Create a new sheet if true, otherwise write to the existing sheet
`range`	Yes	Range of cells in the Excel sheet (e.g., "A1:C10")
`sheetName`	Yes	Sheet name in the Excel file
`values`	Yes	Values to write to the Excel sheet. If the value is a formula, it should start with "="

Input Schema (JSON Schema)

{
  "properties": {
    "fileAbsolutePath": {
      "description": "Absolute path to the Excel file",
      "type": "string"
    },
    "newSheet": {
      "description": "Create a new sheet if true, otherwise write to the existing sheet",
      "type": "boolean"
    },
    "range": {
      "description": "Range of cells in the Excel sheet (e.g., \"A1:C10\")",
      "type": "string"
    },
    "sheetName": {
      "description": "Sheet name in the Excel file",
      "type": "string"
    },
    "values": {
      "description": "Values to write to the Excel sheet. If the value is a formula, it should start with \"=\"",
      "items": {
        "items": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        },
        "type": "array"
      },
      "type": "array"
    }
  },
  "required": [
    "fileAbsolutePath",
    "sheetName",
    "newSheet",
    "range",
    "values"
  ],
  "type": "object"
}

Excel MCP Server

excel_write_to_sheet

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Excel MCP Server

Related Tools

MCP directory API