xlsx

# Workbook workflow Trigger for `.xlsx`, `.xlsm`, `.xltx`, `.csv`, and `.tsv` workbooks or requests to create, read, edit, clean, format, calculate, chart, or convert them. Do not use it for ordinary documents, web pages, databases, or live external spreadsheet APIs. 1. Copy an existing workbook to a unique temporary directory and inspect it with `scripts/inspect_workbook.mjs --input <file> --json` before editing. 2. Preserve formulas, cached values, styles, merges, tables, filters, validations, conditional formatting, charts, images, shapes, comments, hidden sheets, links, macros, and metadata. Only modify the requested cells or objects. 3. After adding or changing formulas run `scripts/recalculate_workbook.mjs --input <file> --output <file> --json`. A completed recalculation with formula errors is reported as `errors_found`; a conversion or process failure is a separate failure. 4. Run `scripts/check_workbook.mjs <file> --json`; use `--allow-lossy` only when the caller explicitly accepts the listed loss. The checker does not use PPTX or XSD data. 5. Render with `scripts/render_with_office.mjs <file> --output-dir <dir>` and inspect every sheet/page. Reopen the output and verify formulas, cached values, objects, and that the original hash is unchanged. CSV/TSV input requires an explicit encoding, BOM, delimiter, quote, newline, and malformed-row policy. Never replace formulas with constants unless a static export was requested. External links, macros, unsupported extensions, and objects that cannot be safely preserved fail closed. All commands are standalone Node CLIs. They write stable JSON with `--json`, diagnostics to stderr, and non-zero status for invalid input, missing Office, timeout, or unsafe preservation. The bundled renderer is resolved through `MEMMY_OFFICE_RENDERING_ROOT`, the legacy DOCX override during migration, the packaged Office payload, and the source payload; it never silently falls back to a system PATH installation. See `references/workbook-workflow.md`, `references/formula-recalculation.md`, and `references/layout-and-preservation.md` for the full SOP.