TRUECALC
MCP

edit:setValues

Sets the values.

Parameters

NameTypeRequiredDescription
sheetstringyes
anchorstringyes
valuesarray of array of stringyes

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",
  "description": "A rectangular block of raw strings, row-major, anchored at `anchor`.",
  "type": "object",
  "properties": {
    "sheet": {
      "type": "string"
    },
    "anchor": {
      "type": "string"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {
          "type": "string"
        }
      }
    }
  },
  "required": [
    "sheet",
    "anchor",
    "values"
  ]
}

On this page