skills.rest
zlsbksdxl
zlsbksdxlCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

lark-sheets

Create and edit Feishu spreadsheets via lark-cli commands for cells, formulas, charts, and pivot tables.

3|2|Updated Jul 21, 2026
Search Tags:#charts#formulas#spreadsheet#feishu#lark#pivot table#lark-cli
One-click install
npx skills add https://github.com/zlsbksdxl/codex-lark --skill lark-sheets-zlsbksdxl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/zlsbksdxl/codex-lark/tree/main/plugins/feishu2codex/skills/lark-sheets
Command: npx skills add https://github.com/zlsbksdxl/codex-lark --skill lark-sheets-zlsbksdxl

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Working with Feishu (Lark) spreadsheets programmatically is error-prone: formulas behave differently from Excel, writes can silently lose data types, and edits are hard to verify. This Skill gives an AI agent a complete, rule-driven workflow for reading, writing, formatting, and validating online spreadsheets through the lark-cli command line. ## Core Features & Use Cases - Full spreadsheet operations: Create workbooks, manage sheets and row/column structure, read and write cell values, formulas, styles, comments, and images, plus search/replace and atomic batch updates. - Data objects and visualization: Build pivot tables, charts, conditional formats, filters, filter views, sparklines, and floating images as real native objects that stay linked to source data. - Formula correctness pipeline: Translate Excel formulas into Feishu-compatible semantics (ARRAYFORMULA, MAP/LAMBDA, date differences) and verify zero-error results with the formula-verify self-check. - Use Case: Ask the agent to build a financial model in a Feishu sheet—it will create the workbook with typed data, apply styling, write verified formulas, add a pivot summary and chart, then read back the results to confirm everything took effect. ## Quick Start Ask the agent to read the Feishu spreadsheet at a given /sheets/ URL and summarize its sheets, then write or update data in a specified range.

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 dtypes and display formats, and +cells-set for formulas, styles, comments, or images. Always locate the sheet with --url plus --sheet-id or --sheet-name, and read back with +csv-get to confirm.

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

Feishu does not spill arrays like Excel 365, so range arithmetic needs ARRAYFORMULA, and per-row patterns need MAP with LAMBDA. Date differences should use DAYS or DATEDIF instead of DAY(end-start). After writing, run +formula-verify until it returns status success.

Does lark-cli support pivot tables and charts in Feishu sheets?▼

Yes. Use +pivot-create for group-by aggregation instead of SUMIF workarounds, and +chart-create for native interactive charts rather than matplotlib images. Both are real spreadsheet objects that update with source data and can be listed and verified afterward.

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

The +csv-put command treats input as plain text and can mangle values like 001 or 12.10. For numeric, percentage, currency, or date data, use +table-put with declared dtypes and formats, or +cells-set with number_format, so values keep their computational type.

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

The skill requires the lark-cli binary and the sibling lark-shared skill, which handles authentication and permission flows. High-risk writes such as deletes and batch clears require the --yes confirmation flag, and --dry-run previews any operation without side effects.

When should I use cell images versus floating images in Feishu sheets?▼

Use +cells-set-image when the picture belongs to a record and must move with row sorting or filtering, such as receipts or product photos. Use +float-image-create only for free-positioned decorations like logos or banners that are not tied to data rows.

Related Skills

Explore More Data & Analytics Skills→
sliecsliec

lark-drive

Manage Lark Drive files, folders, comments, permissions, and document imports via lark-cli.

Community
Advanced
hanabi-jpnhanabi-jpn
3

Lark Workflow

Automate Lark/Feishu messaging, approvals, documents, events, and spreadsheets.

Community
Advanced
navyapdh11navyapdh11

doc-maintenance

Audit documentation drift against git history and open a PR.

Community
Intermediate
U1traVenoU1traVeno

lark-base

Operate Feishu Bitable tables, fields, records, views, dashboards, workflows, and roles via lark-cli.

Community
Advanced