exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh create '表格标题'"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh meta shtcnABC123"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh write TOKEN 'sheetId!A1:C2' '[[\"表头1\",\"表头2\",\"表头3\"],[\"数据1\",100,true]]'"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh prepend TOKEN 'sheetId!A1:C1' '[[\"插入行1\",\"插入行2\",\"插入行3\"]]'"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh insert_image TOKEN 'sheetId!E1:E1' /path/to/image.png"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh float_image TOKEN sheetId /path/to/image.png 'sheetId!F1:F1' 400 300"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh float_image_url TOKEN sheetId 'https://example.com/image.png' 'sheetId!F1:F1' 400 300"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh style_batch TOKEN '{\"data\":[{\"ranges\":\"sheetId!A1:D1\",\"style\":{\"bold\":true}},{\"ranges\":\"sheetId!A2:D10\",\"style\":{\"fontSize\":12}}]}'"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh merge TOKEN 'sheetId!A1:D1' MERGE_ALL"

exec command="~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh unmerge TOKEN 'sheetId!A1:D1'"

飞书电子表格 Skill

通过 exec 调用 ~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh 脚本操作飞书电子表格。

前提条件

1. 1. 飞书应用凭证：~/.openclaw/openclaw.json 中必须配置 channels.feishu，包含 appId 和 appSecret
2. 飞书应用权限：应用需要开通「电子表格」相关权限（sheets:spreadsheet）
3. 系统依赖：curl、python3、bash

凭证自动从 openclaw.json 读取，无需手动配置。可通过 OPENCLAW_CONFIG 环境变量指定配置文件路径。

Token 提取

从 URL https://feishu.cn/sheets/shtcnABC123 → spreadsheet_token = shtcnABC123

---

📊 表格操作

创建电子表格

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh create 表格标题

返回 spreadsheettoken 和 URL。可选第二参数 foldertoken。

获取元数据（必须先调这个拿 sheet_id）

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh meta shtcnABC123

---

📖 数据读写

读取数据

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh read TOKEN sheetId!A1:C10

读取多个范围

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh read_multi TOKEN sheetId!A1:C10 sheetId!E1:F5

写入数据（覆盖指定范围）

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh write TOKEN sheetId!A1:C2 [[\表头1\,\表头2\,\表头3\],[\数据1\,100,true]]

values 是 JSON 二维数组。字符串用引号，数字和布尔值不用。

追加数据（在已有数据后面添加行）

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh append TOKEN sheetId!A1:C1 [[\新行1\,\新行2\,\新行3\]]

前插数据

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh prepend TOKEN sheetId!A1:C1 [[\插入行1\,\插入行2\,\插入行3\]]

---

🖼️ 图片操作

插入图片到单元格（本地文件）

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh insert_image TOKEN sheetId!E1:E1 /path/to/image.png

图片会填充到指定单元格内。Range 必须是单个单元格。

插入浮动图片（本地文件）

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh float_image TOKEN sheetId /path/to/image.png sheetId!F1:F1 400 300

参数：token, sheet_id, 文件路径, 锚点单元格(可选), 宽度(可选), 高度(可选)

插入浮动图片（URL）

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh floatimageurl TOKEN sheetId https://example.com/image.png sheetId!F1:F1 400 300

---

🎨 样式操作

设置单元格样式

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh style TOKEN sheetId!A1:D1 {\bold\:true,\foreColor\:\#FFFFFF\,\backColor\:\#4472C4\,\fontSize\:14}

支持的样式属性：

• - bold (bool) — 加粗
• italic (bool) — 斜体
• foreColor (string) — 字体颜色，如 #FF0000
• backColor (string) — 背景颜色，如 #FFFF00
• fontSize (int) — 字号，如 14
• horizontalAlign (int) — 水平对齐：0=左, 1=中, 2=右
• verticalAlign (int) — 垂直对齐：0=上, 1=中, 2=下
• textDecoration (int) — 0=无, 1=下划线, 2=删除线, 3=两者都有

批量设置样式

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh style_batch TOKEN {\data\:[{\ranges\:\sheetId!A1:D1\,\style\:{\bold\:true}},{\ranges\:\sheetId!A2:D10\,\style\:{\fontSize\:12}}]}

---

🔗 合并单元格

合并

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh merge TOKEN sheetId!A1:D1 MERGE_ALL

合并类型：MERGEALL（全部合并）、MERGEROWS（按行合并）、MERGE_COLUMNS（按列合并）

拆分

bash exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh unmerge TOKEN sheetId!A1:D1

---

📄 工作表操作

bash

添加工作表

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh add_sheet TOKEN 工作表名称

删除工作表

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh delete_sheet TOKEN sheetId

复制工作表

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh copy_sheet TOKEN sourceSheetId 副本名称

---

↕️ 行列操作

bash

末尾加 10 行

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh add_rows TOKEN sheetId 10

末尾加 5 列

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh add_cols TOKEN sheetId 5

在第3行前插入到第5行（0-indexed）

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh insert_rows TOKEN sheetId 3 5

删除第3到第5行

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh delete_rows TOKEN sheetId 3 5

删除第2到第4列

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh delete_cols TOKEN sheetId 2 4

---

🔍 查找替换

bash

查找

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh find TOKEN sheetId 关键词

替换

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh replace TOKEN sheetId 旧文本 新文本

---

常见流程示例

创建带格式的报表

bash

1. 创建表格

exec command=~/.openclaw/skills/feishu-sheet/scripts/feishu-sheet.sh create 月度报表

→ 得到 spreadsheet_token

2. 获取 sheet_id

exec command=~/.openclaw/skills/feishu-sheet/