| name | spreadsheets |
| description | 使用本地开源工具创建、检查、编辑、导出、渲染与校验 XLSX 工作簿。适用于根据结构化数据构建可编辑表格、检查公式与工作表几何、修改单元格、将工作表导出为 CSV、添加常用图表，以及对工作簿输出做视觉审阅。 |
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:
python3 "$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
- Run
inspect before modifying an existing workbook.
- For new workbooks, prepare a JSON specification from spec.md, then run
create.
- Use formulas for auditable calculations. Use
set-cell for focused changes and export-csv for interchange.
- Run
validate after every change.
- Run
render --images, inspect all pages, and correct clipped columns, excessive pagination, or unreadable formatting.
Commands
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.
