# Spreadsheets

> 使用本地开源工具创建、检查、编辑、导出、渲染与校验 XLSX 工作簿。适用于根据结构化数据构建可编辑表格、检查公式与工作表几何、修改单元格、将工作表导出为 CSV、添加常用图表，以及对工作簿输出做视觉审阅。

- Skill: `wecode-ai/spreadsheets` (Agent Skill, multi-file: 7 files)
- Install (CLI): `npx skillmds@latest add wecode-ai/spreadsheets`
- Raw SKILL.md: https://api.skillmd.com/api/skills/wecode-ai/spreadsheets/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: wecode-ai (https://skillmd.com/u/wecode-ai)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/wecode-ai/spreadsheets

---


# Spreadsheets

Use the deterministic workbook CLI and keep calculations editable inside the resulting XLSX. Never overwrite an input workbook.

## Runtime

Prefer workspace dependency Python. Otherwise use Python 3:

On macOS/Linux use `python3`; on Windows PowerShell use `py -3` (or the
workspace dependency loader's absolute `python.exe` path). On Windows set the
skill directory with `$env:SKILL_DIR = '<skill-directory>'`. Every `python3`
example below uses this platform-specific launcher substitution.

```bash
python3 "$SKILL_DIR/scripts/bootstrap.py" <command> [arguments]
```

```powershell
py -3 "$env:SKILL_DIR\scripts\bootstrap.py" <command> [arguments]
```

Missing packages are installed from the hashed lock into `~/.wegent-executor/plugin-envs/wework-public/spreadsheets/`, never globally.

## Workflow

1. Run `inspect` before modifying an existing workbook.
2. For new workbooks, prepare a JSON specification from [spec.md](references/spec.md), then run `create`.
3. Use formulas for auditable calculations. Use `set-cell` for focused changes and `export-csv` for interchange.
4. Run `validate` after every change.
5. Run `render --images`, inspect all pages, and correct clipped columns, excessive pagination, or unreadable formatting.

## Commands

```bash
python3 "$SKILL_DIR/scripts/bootstrap.py" inspect --input source.xlsx --output inspection.json
python3 "$SKILL_DIR/scripts/bootstrap.py" create --spec workbook.json --output result.xlsx
python3 "$SKILL_DIR/scripts/bootstrap.py" set-cell --input source.xlsx --sheet Summary --cell B2 --value-json '125' --output result.xlsx
python3 "$SKILL_DIR/scripts/bootstrap.py" set-cell --input source.xlsx --sheet Summary --cell C2 --formula 'SUM(A2:B2)' --output result.xlsx
python3 "$SKILL_DIR/scripts/bootstrap.py" export-csv --input result.xlsx --sheet Summary --output summary.csv
python3 "$SKILL_DIR/scripts/bootstrap.py" validate --input result.xlsx
python3 "$SKILL_DIR/scripts/bootstrap.py" render --input result.xlsx --output-dir rendered --images
```

## Quality rules

- Store numbers, dates, booleans, and formulas as typed cell values rather than formatted strings.
- Use a styled header, readable column widths, freeze panes, and filters for non-trivial tables.
- Prefer formulas over hard-coded calculated outputs when users need an auditable model.
- Remember that the Python library does not calculate formulas; recalculate with Excel or LibreOffice when current values matter.
- Validate structure and visually review rendered output before delivery.