lark-sheets

Create and edit Lark spreadsheets via lark-cli shortcuts for cells, charts, and pivot tables.

Updated May 22, 2026
One-click install
npx skills add https://github.com/CalWade/aigc-creator --skill lark-sheets-calwade
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/CalWade/aigc-creator/tree/main/.agents/skills/lark-sheets
Command: npx skills add https://github.com/CalWade/aigc-creator --skill lark-sheets-calwade

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Working with Feishu (Lark) online spreadsheets through raw APIs is error-prone: agents guess command names, misplace sheets, write past the real data range, or fake charts and pivot tables with static values. This Skill provides a verified command map and strict workflow rules so spreadsheet operations are executed correctly against the live document. ## Core Features & Use Cases - Full spreadsheet CRUD: create workbooks, manage sheets, insert/delete/resize/freeze rows and columns, read and write cell values, formulas, styles, comments, and cell images. - Data objects: create and maintain charts, pivot tables, conditional formats, filters, filter views, sparklines, and floating images as real spreadsheet objects that update with source data. - Atomic batch updates: combine multiple write operations into a single transactional +batch-update call with dry-run preview and mandatory read-back verification. - Use Case: A user asks to group sales data by region and chart the result. The Skill reads the workbook structure, creates a real pivot table on a new sheet, excludes the grand-total row, and builds a column chart referencing the exact data range. ## Quick Start Ask the AI to read the Feishu spreadsheet at your /sheets/ URL and summarize the data in its first worksheet.

Frequently Asked Questions about lark-sheets

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

FAQPage Schema
How do I read data from a Feishu spreadsheet with lark-cli?▼

Use `lark-cli sheets +csv-get` with `--url` or `--spreadsheet-token` plus `--sheet-id` or `--sheet-name` and a `--range`. For formulas, styles, or comments, use `+cells-get --include value,formula,style,comment` instead.

How do I create a chart or pivot table in a Lark sheet?▼

Use `+chart-create` for charts and `+pivot-create` for pivot tables; both create real spreadsheet objects that update with source data. Never substitute matplotlib images or SUMIF-based fake summaries, and exclude grand-total rows when charting pivot output.

Can this skill edit local Excel files?▼

No. It only operates on Feishu online spreadsheets located by a /sheets/ or /spreadsheets/ URL or a spreadsheet token. Local Excel files are out of scope, though Excel formulas can be translated into Feishu-executable formulas.

Why does my sheet command fail with a sheet not found error?▼

The sheet name was probably guessed, such as defaulting to Sheet1. Run `+workbook-info` first to list actual sheet titles and IDs, then pass the real value via `--sheet-id` or `--sheet-name`; a range prefix like Sheet1! does not replace sheet locating flags.

How do I run multiple spreadsheet writes atomically?▼

Combine the operations into one `+batch-update` call with an `--operations` JSON array; it executes sequentially and aborts on the first failure. High-risk writes require `--yes`, and `--dry-run` previews every sub-operation without side effects.

Can I use a Feishu wiki link to locate a spreadsheet?▼

Not directly. Wiki links are not parsed into spreadsheet tokens, so first resolve the node with `lark-cli wiki +node-get`, confirm obj_type is sheet, then pass its obj_token as `--spreadsheet-token`.