xlsx

Capabilities

Full Excel read/write and formatting:

Capability	Details
Create / open	New workbooks; parse existing files
Cells	Read / write / clear / merge / split
Rows & columns	Insert / delete / resize / hide
Formatting	Fonts, colors, borders, fills, alignment, number formats
Multiple sheets	Add/remove, switch, duplicate, rename
Formulas	SUM, VLOOKUP, IF, custom ranges
Conditional formatting	Databars, color scales, icon sets
Charts	Columns, bars, pies, lines, scatter, …
Images	Embed in-cell or floating
Freeze panes / filters / outlines	Common view ergonomics

Scenario	Notes
Data reports	Export structured data into polished spreadsheets
Template fills	Contracts, reconciliation sheets, billing cadences
Pivots	Multi-sheet dashboards
Rich exports	Color defects or categories for review outputs
Test matrices	Requirements × tests × ASIL cubes
Compliance matrices	ASPICE process areas × artifact coverage

Not for:

Skill	Role	Use when
xlsx	Spreadsheet primitives	Authoring from scratch, large exports, charts
document-editing	CoW editing framework	Partial edits to existing xlsx while preserving styling

Typical combos:

New export:           user → xlsx → artifact
Localized edits:      user → document-editing → calls xlsx → artifact

Natural language inside a session works:

Or slash:

/xlsx Export this dataset to Excel with category colors

Issue	Mitigation
Garbled Chinese fields	Prefer UTF-8; avoid legacy `.xls`, stick to `.xlsx`
Writes fail on merged cells	Unmerge, write, re-merge
Huge files (>1M rows) slow	Streaming `read_only=True` / `write_only=True`
Formulas not evaluated	Excel recalcs on open; servers may need `workbook.calculate` or library eval
Chart anchors drift	Pin to anchor cells via `oneCellAnchor`/`twoCellAnchor`