skills.rest
DeepJH
DeepJHCOMMUNITY
Explore all skills by this author →
GitHub

lark-sheets

Create, edit, analyze, and visualize local Excel files and Feishu online spreadsheets.

2|Updated Aug 9, 2026
Search Tags:#data analysis#visualization#formulas#spreadsheet#excel#feishu#pivot table
One-click install
npx skills add https://github.com/DeepJH/doubao-skill-and-info --skill lark-sheets-deepjh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/DeepJH/doubao-skill-and-info/tree/main/skills/lark-sheets
Command: npx skills add https://github.com/DeepJH/doubao-skill-and-info --skill lark-sheets-deepjh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, and includes scripts (resource) and references (resource) components.

What problem does it solve? Handling spreadsheet tasks across two worlds—local Excel/CSV files and Feishu (Lark) online spreadsheets—requires different tools, formulas, and delivery formats. This Skill unifies both into one workflow, routing each task to the right engine (Python/openpyxl for local files, lark-cli for online sheets) and enforcing rules that prevent common failures like hardcoded values, broken formulas, and lossy imports. ## Core Features & Use Cases - Dual-engine spreadsheet processing: Read, write, analyze, and format local .xlsx/.xls/.csv files with Python (pandas/openpyxl) or operate Feishu online spreadsheets via lark-cli, with one-command import of local workbooks into Feishu. - Native online objects: Create pivot tables, charts, sparklines, conditional formats, filters, cell-embedded images, and dropdowns as real Feishu objects that stay linked to source data instead of static screenshots or dead tables. - Formula-first discipline with verification: Write live formulas rather than precomputed values, translate Excel formulas to Feishu syntax, and run formula verification until zero errors (#REF!, #DIV/0!, etc.) before delivery. - Use Case: A user uploads a sales .xlsx and asks for a grouped summary with a trend chart. The Skill inspects the workbook, imports it into Feishu, builds a native pivot table and chart, verifies all formulas, and delivers the online spreadsheet link. ## Quick Start Upload an Excel file or paste a Feishu spreadsheet link and ask the AI to analyze, summarize, or visualize the data in a spreadsheet.

Frequently Asked Questions about lark-sheets

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

FAQPage Schema
How do I import a local Excel file into a Feishu online spreadsheet?▼

Use lark-cli sheets +workbook-import with the --file flag pointing to a relative path like ./file.xlsx. It supports .xlsx, .xls, and .csv, and optionally accepts --folder-token and --name for the destination and document title.

How do I create a pivot table in a Feishu spreadsheet?▼

Use the +pivot-create shortcut of lark-cli sheets after locating the workbook with --url and the sheet with --sheet-id or --sheet-name. Group-by summaries must use native pivot tables rather than SUMIF formulas or pandas groupby written back as static values.

Can Excel formulas be used directly in Feishu spreadsheets?▼

Not always; Feishu formulas differ from Excel in functions like ARRAYFORMULA, INDEX/OFFSET, and MAP/LAMBDA, so formulas must be rewritten following the formula translation rules. After writing, run +formula-verify until it returns status success with zero errors.

Why should charts not be generated with matplotlib for Feishu spreadsheets?▼

Matplotlib produces static PNG images that cannot update when source data changes and lose interactivity in Feishu. The +chart-create shortcut builds native chart objects that stay linked to the data range and remain interactive.

What happens when openpyxl cannot open a corrupted Excel file?▼

The recommended fallback is importing the file into Feishu with +workbook-import, whose server-side parser tolerates files that break local libraries. Manually unzipping the xlsx and parsing raw XML locally is explicitly discouraged.

When is a local .xlsx file delivered instead of a Feishu online spreadsheet?▼

The default deliverable is always a Feishu online spreadsheet link. A local .xlsx or .csv file is produced only when the user explicitly forbids using Feishu spreadsheets or explicitly requests a plain local CSV file.

Related Skills

Explore More Data & Analytics Skills→
SillyHippySillyHippy

enrich-csv

Adds AI-generated columns to CSV files by processing rows through the Zo API.

Community
Intermediate
CyandexCyandex

feishu-perm

Manages Feishu document and file permissions via a single feishu_perm tool.

Community
Basic
alessandro9110alessandro9110
4

databricks-unity-catalog

Query Unity Catalog system tables and manage files in volumes.

Community
Intermediate
fatihkanfatihkan
7

data-analytics

Analyze datasets and generate analytics reports with visuals.

Community
Advanced