所有工具

excel_write_cell

文档 · macOS · Windows

效果: 写入. 状态: 受限可用.

“受限可用”表示工具可能取决于版本、平台、权限、账户或配置,并不表示它在所有安装中都已启用。

macOS

用途

向 Excel 文件中的特定单元格写入值。看似数字的值字符串仅在能够完全无损往返时才会作为数字写入,否则仍保留为文本。可使用 A1 表示法的 `cell`(例如 “B2”),或使用从 1 开始计数的整数 `row`+`column` 来指定单元格。

必填输入

输入名称会严格保持工具要求的形式。下方可展开的架构中保留英文规范技术定义。

权限与确认

架构声明了明确的确认参数。请检查预览,并按此平台的契约授权实际操作。

英文规范技术架构macOS
{
  "properties": {
    "cell": {
      "description": "Cell in A1 notation, e.g. \"B2\" (alternative to row+column)",
      "type": "string"
    },
    "column": {
      "description": "Column number (1-based) — use with `row`, or use `cell` instead",
      "type": "integer"
    },
    "confirm": {
      "description": "Must be true to modify",
      "type": "boolean"
    },
    "path": {
      "description": "Path to the .xlsx file",
      "type": "string"
    },
    "row": {
      "description": "Row number (1-based) — use with `column`, or use `cell` instead",
      "type": "integer"
    },
    "sheet_name": {
      "description": "Sheet name (default: first sheet)",
      "type": "string"
    },
    "value": {
      "description": "Value to write",
      "type": "string"
    }
  },
  "required": [
    "path",
    "value"
  ],
  "type": "object"
}

文档示例

excel_write_cell 的文档示例。请勿执行此示例。所示参数属于虚构数据集;在实际调用前,请解析真实标识符并获得授权。

{
  "cell": "B2",
  "confirm": false,
  "path": "/Users/demo/Documents/launch-checklist.xlsx",
  "value": "Reviewed"
}

Windows

用途

向现有 Excel 文件中的特定单元格写入值。

必填输入

输入名称会严格保持工具要求的形式。下方可展开的架构中保留英文规范技术定义。

权限与确认

架构声明了明确的确认参数。请检查预览,并按此平台的契约授权实际操作。

英文规范技术架构Windows
{
  "properties": {
    "cell": {
      "description": "Cell reference (e.g., B2) — alternative to row+column",
      "type": "string"
    },
    "column": {
      "description": "Column number (1-based) — use with `row`, alias for `cell`. The name the cloud catalog (Mac) advertises.",
      "type": "integer"
    },
    "confirm": {
      "description": "Must be true to write",
      "type": "boolean"
    },
    "path": {
      "description": "Path to .xlsx file",
      "type": "string"
    },
    "row": {
      "description": "Row number (1-based) — use with `column`, alias for `cell`",
      "type": "integer"
    },
    "sheet_name": {
      "description": "Name of the sheet to write to (default: first sheet). The name the cloud catalog (Mac) advertises.",
      "type": "string"
    },
    "value": {
      "description": "Value to write",
      "type": "string"
    }
  },
  "required": [
    "path",
    "value"
  ],
  "type": "object"
}

文档示例

excel_write_cell 的文档示例。请勿执行此示例。所示参数属于虚构数据集;在实际调用前,请解析真实标识符并获得授权。

{
  "cell": "B2",
  "confirm": false,
  "path": "C:\\Users\\demo\\Documents\\launch-checklist.xlsx",
  "value": "Reviewed"
}