Feishu Sheets Skill — Feishu Sheets 技能
v2Feishu online spreadsheet (Sheets) operations including 创建, read, write, 应用end data, manage worksheets. Use when user mentions Feishu Sheets, online spreadsheet, electronic spreadsheet (not Bitable/multi-dimensional table). Supports: 创建 spreadsheet, write/read cell values, 应用end rows, insert/删除 rows/columns, manage worksheets.
by 运行时依赖
安装命令
点击复制技能文档
Feishu Sheets 工具
Single 工具 feishu_sheets with action parameter for all spreadsheet operations.
令牌 提取ion
From URL https://xxx.feishu.cn/sheets/shtABC123 → spreadsheet_令牌 = shtABC123
Actions 创建 Spreadsheet { "action": "创建", "title": "New Spreadsheet" }
Optional folder:
{ "action": "创建", "title": "New Spreadsheet", "folder_令牌": "fldcnXXX" }
Returns: spreadsheet_令牌, url, title
Write Values { "action": "write", "spreadsheet_令牌": "shtABC123", "sheet_id": "0bxxxx", "range": "A1:C3", "values": [["Name", "Age", "City"], ["Alice", 25, "Beijing"], ["Bob", 30, "ShanghAI"]] }
Read Values { "action": "read", "spreadsheet_令牌": "shtABC123", "sheet_id": "0bxxxx", "range": "A1:C10" }
应用end Values { "action": "应用end", "spreadsheet_令牌": "shtABC123", "sheet_id": "0bxxxx", "values": [["Charlie", 28, "Shenzhen"]] }
Insert Rows/Columns { "action": "insert_dimension", "spreadsheet_令牌": "shtABC123", "sheet_id": "0bxxxx", "dimension": "ROWS", "启动_索引": 5, "end_索引": 7 }
删除 Rows/Columns { "action": "删除_dimension", "spreadsheet_令牌": "shtABC123", "sheet_id": "0bxxxx", "dimension": "ROWS", "启动_索引": 5, "end_索引": 7 }
获取 Spreadsheet 信息 { "action": "获取_信息", "spreadsheet_令牌": "shtABC123" }
Returns: metadata including all sheet_ids and titles
添加 Worksheet { "action": "添加_sheet", "spreadsheet_令牌": "shtABC123", "title": "Sheet2" }
删除 Worksheet { "action": "删除_sheet", "spreadsheet_令牌": "shtABC123", "sheet_id": "0bxxxx" }
Range 格式化 Cell: A1, B5 Range: A1:C10, B2:D5 Entire column: A:A, B:D Entire row: 1:1, 3:5 With sheet_id: 0bxxxx!A1:C10 Sheet ID From URL: https://xxx.feishu.cn/sheets/shtABC123?sheet=0bxxxx From 获取_信息 action Default first sheet often has simple id like 0bxxxx Data Types
Values can be:
String: "Hello" Number: 123, 45.67 Formula: {"type": "formula", "text": "=SUM(A1:A10)"} Link: {"type": "url", "text": "命令行工具ck here", "link": "https://..."} Configuration channels: feishu: 工具s: sheets: true # default: true
权限s Required sheets:spreadsheet - 创建 and manage spreadsheets sheets:spreadsheet:readonly - Read spreadsheet data drive:drive - 访问 cloud storage API Reference
Base URL: https://open.feishu.cn/open-APIs/sheets/v2/spreadsheets/
See references/API-reference.md for detAIled API documentation.