lark-sheets

Create and edit Feishu spreadsheets via lark-cli shortcuts with formulas, charts, and pivot tables.

8|2|Updated Apr 29, 2026
One-click install
npx skills add https://github.com/luojiaaoo/xpeech --skill lark-sheets-luojiaaoo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/luojiaaoo/xpeech/tree/main/xpeech/agent/skills/buildin/lark-skills/lark-sheets
Command: npx skills add https://github.com/luojiaaoo/xpeech --skill lark-sheets-luojiaaoo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires lark-cli, and includes references (resource) and scripts (resource) components.

What problem does it solve? Working with Feishu (Lark) online spreadsheets through an AI agent is error-prone: wrong command names, lost cell types, broken formulas after Excel migration, and unverified writes. This Skill provides a complete, verified command vocabulary and editing discipline for creating and manipulating Feishu spreadsheets through the lark-cli sheets interface. ## Core Features & Use Cases - Full spreadsheet lifecycle: Create workbooks, manage sheets, insert/delete/resize rows and columns, read and write cells with values, formulas, styles, comments, and embedded images. - Data objects: Build charts, pivot tables, conditional formats, filters, filter views, sparklines, and floating images as real native objects rather than static workarounds. - Formula correctness pipeline: Translate Excel formulas into Feishu-executable semantics (ARRAYFORMULA, MAP/LAMBDA, native array functions) and verify zero-error results with +formula-verify. - Use Case: Ask the agent to import an xlsx file into Feishu, add a summary pivot table grouped by region, draw a column chart excluding the total row, and apply conditional formatting to highlight overdue dates. ## Quick Start Ask the agent to read the Feishu spreadsheet at your sheet URL and summarize its sheets, then append a new row of data with inherited styling.

Frequently Asked Questions about lark-sheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write data to a Feishu spreadsheet from the command line?▼

Use lark-cli sheets shortcuts: +csv-put for plain text blocks, +table-put for typed data with numbers and dates, and +cells-set for formulas, styles, or precise ranges. Always locate the sheet with --url plus --sheet-id or --sheet-name first.

How do I convert Excel formulas to Feishu spreadsheet formulas?▼

Feishu does not spill arrays like Excel 365, so wrap range arithmetic in ARRAYFORMULA and use MAP with LAMBDA for per-row iteration. After writing formulas, run +formula-verify until it returns status success to confirm zero errors.

Can I create charts and pivot tables in Feishu sheets programmatically?▼

Yes. Use +chart-create with a --properties JSON for native charts and +pivot-create for real pivot tables instead of SUMIF workarounds. When charting pivot output, exclude the grand total row from the data refs.

Why did my CSV upload turn numbers and dates into text in Feishu?▼

+csv-put writes everything as plain text, so values like 12.10 or 001 get mangled or lose numeric semantics. Use +table-put with dtypes and formats, or +workbook-create --sheets, to preserve number, percent, and date types.

What permissions and tools are required to use lark-cli sheets commands?▼

The lark-cli binary must be installed and the companion lark-shared skill handles authentication and permission scopes. High-risk writes like +batch-update or +cells-clear require a --dry-run preview and explicit user approval before adding --yes.

How do I verify an AI agent actually edited my Feishu spreadsheet correctly?▼

Record the revision before editing with +revision-get, then run +changeset-get --start-revision to list the raw change actions between versions. Read back affected ranges with +csv-get or +cells-get to confirm the final state.