飞书表格工具

单一工具feishu_sheets包含用于所有电子表格操作的动作参数。

令牌提取

从 URLhttps://xxx.feishu.cn/sheets/shtABC123→spreadsheet_token=shtABC123

操作

创建电子表格

{ "action": "create", "title": "New Spreadsheet" }

可选文件夹：

{ "action": "create", "title": "New Spreadsheet", "folder_token": "fldcnXXX" }

返回：spreadsheet_token、url、标题

写入数值

{
  "action": "write",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "range": "A1:C3",
  "values": [["Name", "Age", "City"], ["Alice", 25, "Beijing"], ["Bob", 30, "Shanghai"]]
}

读取数值

{
  "action": "read",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "range": "A1:C10"
}

追加数值

{
  "action": "append",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "values": [["Charlie", 28, "Shenzhen"]]
}

插入行/列

{
  "action": "insert_dimension",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "dimension": "ROWS",
  "start_index": 5,
  "end_index": 7
}

删除行/列

{
  "action": "delete_dimension",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "dimension": "ROWS",
  "start_index": 5,
  "end_index": 7
}

获取电子表格信息

{ "action": "get_info", "spreadsheet_token": "shtABC123" }

返回：包含所有 sheet_id 和标题的元数据

添加工作表

{
  "action": "add_sheet",
  "spreadsheet_token": "shtABC123",
  "title": "Sheet2"
}

删除工作表

{
  "action": "delete_sheet",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx"
}

范围格式

• 单元格：A1，B5
• 范围：A1:C10，B2:D5
• 整列：A:A，B:D
• 整行：1:1，3:5
• 带工作表ID：0bxxxx!A1:C10

工作表ID

• 从URL获取：https://xxx.feishu.cn/sheets/shtABC123?sheet=0bxxxx
• 从获取信息操作
• 默认的第一个工作表通常有简单的ID，如0bxxxx

数据类型

数值可以是：

• 字符串："你好"
• 数字：123,45.67
• 公式：{"type": "formula", "text": "=SUM(A1:A10)"}
• 链接：{"type": "url", "text": "点击此处", "link": "https://..."}

配置

channels:
  feishu:
    tools:
      sheets: true  # default: true

所需权限

• sheets:spreadsheet- 创建和管理电子表格
• sheets:spreadsheet:readonly- 读取电子表格数据
• drive:drive- 访问云存储

API参考

基础URL：https://open.feishu.cn/open-apis/sheets/v2/spreadsheets/

详细API文档请参见references/api-reference.md。