lark-sheets

Create, read, write, append, and export Feishu/Lark Sheets via lark-cli.

Updated Sep 4, 2025
One-click install
npx skills add https://github.com/ykai55/dotfiles --skill lark-sheets-ykai55
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/ykai55/dotfiles/tree/main/opencode/skills/lark-sheets
Command: npx skills add https://github.com/ykai55/dotfiles --skill lark-sheets-ykai55

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It eliminates manual spreadsheet work by enabling programmatic creation, reading, updating, and exporting of Feishu/Lark Sheets data, including safe handling of URLs/tokens and cell-range operations.

Core Features & Use Cases

  • Create & initialize spreadsheets: Create a sheet with an optional header row and initial dataset.
  • Read & search cell data: Read cell values with rich-text flattening and find specific content within a known spreadsheet.
  • Write & append rows: Overwrite a cell rectangle or append rows safely with size validation and dry-run preview.
  • Export for sharing and offline use: Export to xlsx/csv via async task polling, optionally downloading to a local file.
  • Correct token handling (including wiki links): Resolves wiki tokens by querying node type first, then routes to the correct API for the real document token.

Quick Start

Ask to create a spreadsheet named 仓库管理营收报表 with headers and initial data using lark-cli sheets +create and then return the created url and spreadsheet_token.

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 cell ranges in Feishu spreadsheets programmatically?

You can read and write cell ranges in Feishu spreadsheets by using authenticated lark-cli Sheets commands. The Skill flattens rich-text for reading and validates size with dry-run previews before appending rows or overwriting cell rectangles.

How do I resolve a spreadsheet token from a Lark wiki URL?

To resolve a spreadsheet token from a Lark wiki URL, the Skill queries the node type first, then routes to the correct API to retrieve the real document token. This ensures safe handling of wiki links for subsequent spreadsheet operations.

Can I export a Lark Sheet to xlsx or csv for offline sharing?

Yes, you can export a Lark Sheet to xlsx or csv. The Skill uses async task polling to handle the export process and can optionally download the exported file directly to a local destination for offline sharing.

How do I create a Feishu spreadsheet with an initial dataset and headers?

You can create a Feishu spreadsheet with an initial dataset by using the create command to initialize a new sheet. This allows you to set an optional header row alongside initial data, returning the created url and spreadsheet_token.

Do I need lark-cli to automate bulk data population in Lark Sheets?

Yes, authenticated lark-cli Sheets commands are required to automate bulk data population in Lark Sheets. The Skill relies on lark-cli to execute cell write and append operations safely with size validation.

What is the best way to find specific content within a known Feishu spreadsheet?

The best way to find specific content within a known Feishu spreadsheet is to use the Skill's search functionality. It reads cell values with rich-text flattening to locate specific data within the document using the resolved spreadsheet token.