lark-sheets

Create and edit Lark spreadsheets via lark-cli, covering cells, charts, pivot tables, and formatting.

Updated Jun 29, 2026
One-click install
npx skills add https://github.com/trungpr1990-coder/AMI-MAKEUP --skill lark-sheets-trungpr1990-coder
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/trungpr1990-coder/AMI-MAKEUP/tree/main/.agents/skills/lark-sheets
Command: npx skills add https://github.com/trungpr1990-coder/AMI-MAKEUP --skill lark-sheets-trungpr1990-coder

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Working with Feishu (Lark) spreadsheets programmatically is error-prone: agents guess wrong command names, lose number/date types when writing data, break formulas during Excel migration, and leave half-finished edits. This Skill provides a complete, verified command map and strict workflow rules for operating Lark spreadsheets through lark-cli. ## Core Features & Use Cases - Full spreadsheet lifecycle: create workbooks, import/export xlsx/csv, manage sheets, rows, columns, merges, freeze panes, and read/write cell values, formulas, styles, comments, and embedded images. - Data objects and visualization: create and maintain charts, pivot tables, conditional formats, filters, filter views, sparklines, and floating images as real spreadsheet objects that update with source data. - Formula and style governance: authoritative rules for translating Excel formulas to Feishu (ARRAYFORMULA, MAP/LAMBDA, date differences, unsupported functions) plus visual styling standards and atomic batch updates with read-back verification. - Use Case: A user asks to build a sales summary: the Skill reads the workbook structure, writes typed data with +table-put, creates a pivot table for group aggregation, adds a chart excluding total rows, and verifies results by reading back the affected ranges. ## Quick Start Ask the AI to read the Lark spreadsheet at your /sheets/ URL and summarize or edit its data using the lark-sheets skill.

Frequently Asked Questions about lark-sheets

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

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

Use lark-cli sheets shortcuts: +csv-get reads values by range, +cells-get reads values with formulas, styles, and comments, and +cells-set or +csv-put write data back. Every call needs a spreadsheet locator (--url or --spreadsheet-token) plus a sheet locator (--sheet-id or --sheet-name).

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

Use +pivot-create with a --source range covering the header row, letting it auto-create a destination sheet. For charts, use +chart-create with a --properties JSON defining position, size, and data refs, then verify with +chart-list.

Why did my numbers or dates turn into text when writing to Feishu sheets?▼

Writing pre-formatted strings like "$1,234" through +csv-put stores them as text that cannot be summed or charted. Use +table-put for existing sheets or +workbook-create for new ones, passing dtypes and formats so numeric and date types are preserved.

Can Excel formulas be used directly in Feishu spreadsheets?▼

Not directly. Feishu does not spill arrays like Excel 365, lacks @ and # operators, and does not support functions like STOCKHISTORY or CUBE formulas. Formulas must be rewritten using ARRAYFORMULA, MAP/LAMBDA, or native array functions, then verified against a local recomputation.

What is the difference between cell images and floating images in Lark sheets?▼

Cell images embed inside a cell and move with its row during sorting or filtering, created via +cells-set-image for record-bound pictures like receipts or avatars. Floating images are freely positioned decorations like logos, managed with +float-image-create.

Why does my lark-cli sheets command fail with a sheet not found error?▼

The sheet name was likely guessed as Sheet1, which many workbooks do not use. Run +workbook-info first to list actual sheet IDs and titles, then pass the real value via --sheet-id or --sheet-name.