TRUECALC
MCP

edit:setCell

Sets the cell.

Parameters

NameTypeRequiredDescription
sheetstringyesThe sheet name.
a1stringyesTarget cell, e.g. "A1".
valuestringyesRaw input: a literal, a formula, leading =, or "" to clear.
inputMode"raw" or nullno

Returns

Nothing beyond the standard MCP success envelope.

Schema

Request payload, as JSON Schema:

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Payload",
  "type": "object",
  "properties": {
    "sheet": {
      "description": "The sheet name.",
      "type": "string"
    },
    "a1": {
      "description": "Target cell, e.g. `\"A1\"`.",
      "type": "string"
    },
    "value": {
      "description": "Raw input: a literal, a formula, leading `=`, or `\"\"` to clear.",
      "type": "string"
    },
    "inputMode": {
      "anyOf": [
        {
          "$ref": "#/$defs/InputMode"
        },
        {
          "type": "null"
        }
      ]
    }
  },
  "required": [
    "sheet",
    "a1",
    "value"
  ],
  "$defs": {
    "InputMode": {
      "type": "string",
      "enum": [
        "raw"
      ]
    }
  }
}

On this page