Excel Author

Documents

excel-author

Excel Author is an Agent Skill for documents published in the fuyuxiang/echo-agent repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Create and edit Excel (.xlsx) workbooks with openpyxl. Supports formulas, charts, formatting, and data analysis.

View on GitHub ↗

QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

Open your project in Codex.
Copy and paste the prompt below.
Review files and risks before approving any action.

Prompt to paste

Inspect the Agent Skill at https://github.com/fuyuxiang/echo-agent/blob/HEAD/skills/creative/excel-author/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/excel-author, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

Excel Author

Create professional Excel workbooks programmatically.

Install

pip install openpyxl

Quick Start

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side

wb = Workbook()
ws = wb.active
ws.title = "月度报表"

# Headers
headers = ["日期", "类别", "金额", "备注"]
ws.append(headers)
for cell in ws[1]:
    cell.font = Font(bold=True, size=12)
    cell.fill = PatternFill("solid", fgColor="4472C4")
    cell.font = Font(bold=True, color="FFFFFF")

# Data
ws.append(["2026-06-01", "餐饮", 85.5, "午餐"])
ws.append(["2026-06-01", "交通", 15.0, "地铁"])
ws.append(["2026-06-02", "购物", 299.0, ""])

# Formula
ws.append(["", "合计", "=SUM(C2:C4)", ""])

# Auto-width
for col in ws.columns:
    max_len = max(len(str(cell.value or "")) for cell in col)
    ws.column_dimensions[col[0].column_letter].width = max_len + 4

wb.save("report.xlsx")

Script

python3 scripts/create_xlsx.py from-csv data.csv --output report.xlsx
python3 scripts/create_xlsx.py from-json data.json --output report.xlsx
python3 scripts/create_xlsx.py quick "Report Title" --headers Name Age City --output output.xlsx

Templates

Expense Report: Category breakdown with totals
Project Tracker: Status, assignee, due date columns
Data Analysis: Summary statistics + charts

Charts

from openpyxl.chart import BarChart, Reference

chart = BarChart()
chart.title = "月度支出"
data = Reference(ws, min_col=3, min_row=1, max_row=5)
cats = Reference(ws, min_col=2, min_row=2, max_row=5)
chart.add_data(data, titles_from_data=True)
chart.set_categories(cats)
ws.add_chart(chart, "E2")

Conventions

Blue cells: input values
Black cells: calculated/formula
Green cells: final output/results