lark-sheets

Create and edit Lark spreadsheet workbooks, cells, charts, and pivot tables via lark-cli.

Updated Jun 26, 2026
One-click install
npx skills add https://github.com/dulltackle/kangkang-skills --skill lark-sheets-dulltackle
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/dulltackle/kangkang-skills/tree/main/lark-sheets
Command: npx skills add https://github.com/dulltackle/kangkang-skills --skill lark-sheets-dulltackle

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve? Working with Feishu (Lark) spreadsheets programmatically requires navigating dozens of API operations for sheets, cells, formulas, charts, pivot tables, filters, and conditional formats. This Skill maps natural-language spreadsheet tasks to the correct lark-cli sheets commands, enforces safe editing practices, and prevents common mistakes like wrong command names, lost formatting, or unverified writes. ## Core Features & Use Cases - Full spreadsheet lifecycle: Create workbooks, manage sheets and row/column structure, read and write cell values, formulas, styles, comments, and embedded images. - Data objects and visualization: Build native charts, pivot tables, conditional formats, filters, filter views, sparklines, and floating images that stay live and update with source data. - Safe editing discipline: Built-in rules for minimal-change edits, style inheritance on inserted rows/columns, formula-first calculations, batch updates with dry-run approval, and mandatory read-back verification. - Use Case: Ask the agent to import a local xlsx file into Feishu, add a summary sheet with formulas and a column chart, apply consistent styling, and verify the results were written correctly. ## Quick Start Use the lark-sheets skill to read the data in this Feishu spreadsheet URL, add a totals row with formulas, and create a column chart comparing each category.

Frequently Asked Questions about lark-sheets

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

FAQPage Schema
How do I create and edit a Feishu spreadsheet from the command line?

Use lark-cli sheets shortcuts such as +workbook-create to build a new spreadsheet with typed data and +cells-set or +table-put to write values, formulas, and styles. Locate the target with --url or --spreadsheet-token plus --sheet-id or --sheet-name.

How do I add a chart or pivot table to a Lark spreadsheet?

Create charts with +chart-create-basic (or +batch-chart-create for multiple) and pivot tables with +pivot-create. These produce native, interactive objects that update with source data, unlike pasted static images.

Can I import a local Excel or CSV file into Feishu Sheets?

Yes, run +workbook-import --file ./x.xlsx to convert a local xlsx, xls, or csv file into a Feishu spreadsheet. To add sheets to an existing workbook instead, copy a template sheet with +sheet-copy and write data with +cells-set.

Why did my Excel formula break after writing it to Feishu Sheets?

Feishu formula semantics differ from Excel, so formulas must be rewritten per the formula translation rules rather than copied verbatim. After writing, run +formula-verify to scan for errors like #REF! or #VALUE! and diagnose failures.

What happens when a delete or batch write command exits with code 10?

Exit code 10 means the command is a high-risk write requiring confirmation. Preview it with --dry-run, show the user the affected scope, and only re-run with --yes after explicit approval.

When should I use cell images versus floating images in a sheet?

Use +cells-set-image when the picture belongs to a record and must move with its row during sorting or filtering, such as receipts or avatars. Use +float-image-create only for free-floating decorations like logos or banners.