lark-sheets
Installation
Summary
Create, manage, and manipulate Lark spreadsheets with full cell and sheet control.
- Supports spreadsheet creation, sheet operations (create/copy/delete/update), and cell data management (read/write/append/find/replace)
- Handles rich cell types including formulas, links with text, @mentions, @documents, and dropdown lists via object-format syntax
- Provides row/column management, cell styling, merging, image insertion, filter views, and floating image support
- Includes async export functionality and cross-sheet formula references (IMPORTRANGE) with up to 5 nesting levels
- Requires
lark-clibinary and proper authentication via shared Lark credentials; wiki links require node type resolution before use
SKILL.md
sheets
CRITICAL — 开始前 MUST 先用 Read 工具读取 ../lark-shared/SKILL.md,其中包含认证、权限处理。
术语约定
下列词在本 skill 各文档中可能交替出现,但指同一对象;解析用户口语时按此映射,不要当成不同概念:
| 标准用语 | 同义 / 口语(均指同一对象) | 说明 |
|---|---|---|
| 工作表(sheet) | 子表、tab、标签页 | spreadsheet 内的单张表;sheet_id 是其稳定标识 |
| 电子表格(spreadsheet) | 工作簿、表格 | 顶层容器;由 --url 或 --spreadsheet-token 定位 |
| reference_id | id | 表内对象的稳定标识,即各对象主键 flag 接受的值(见下表)。⚠️ 与 lark-sheets-float-image 的 --image-uri(图片上传句柄)不是一回事,后者不属于 reference_id |
每类对象用各自的主键 flag 定位(命名不统一,按此表对照,不要凭直觉拼):