xlsx

Create and edit Excel workbooks with formulas, formatting, and recalculation-based verification.

2|1|Updated Mar 30, 2026
One-click install
npx skills add https://github.com/atlasgroupcz/codexis-marketplace --skill xlsx-atlasgroupcz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/atlasgroupcz/codexis-marketplace/tree/main/plugins/documents/skills/xlsx
Command: npx skills add https://github.com/atlasgroupcz/codexis-marketplace --skill xlsx-atlasgroupcz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires exceljs.

What problem does it solve? Spreadsheets generated by AI often contain hardcoded values instead of live formulas, broken references like #REF! or #DIV/0!, and formatting that falls apart when opened in Excel. This Skill builds and edits .xlsx workbooks where every derived value is a real formula, then verifies the result through recalculation and visual rendering before delivery. ## Core Features & Use Cases - Workbook Creation and Editing: Build or modify .xlsx files with ExcelJS, applying proper number formats, column widths, and the blue-input/black-formula financial modeling color convention. - Formula Verification: Recalculate workbooks with cdx-recalc to detect error cells (#REF!, #DIV/0!, #NAME?) and iterate until the workbook reports zero errors. - Visual Review: Render sheets to PNG images with cdx-render to catch layout issues like ### columns, raw float formatting, and text overflow. - Use Case: Ask for a twelve-month cash flow model and receive a workbook where totals, growth rates, and margins are live formulas that update when you change any input cell. ## Quick Start Ask the assistant to create an Excel workbook with a twelve-month cash flow including formulas, and to verify it contains no error cells.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel file with formulas in JavaScript?▼

Use the ExcelJS library to build workbooks programmatically, assigning formulas as objects like { formula: 'SUM(B2:B9)' } to cells. Derived values must be formulas, never computed constants, so the spreadsheet recalculates when inputs change.

How do I check an Excel workbook for formula errors?▼

Run cdx-recalc on the workbook to recalculate all formulas with LibreOffice and report error cells such as #REF!, #DIV/0!, or #NAME?. Exit code 2 means errors were found; fix the formulas and rerun until it reports zero errors.

Why should spreadsheet totals be formulas instead of computed values?▼

A hardcoded total freezes the number, so changing any input leaves the total silently wrong. Writing a formula like SUM(B2:B9) lets the spreadsheet recalculate automatically whenever the user edits an input cell.

Which Excel functions should be avoided when generating xlsx files?▼

Avoid dynamic array functions like FILTER, XLOOKUP, SORT, and SEQUENCE because ExcelJS and LibreOffice do not round-trip them in a way Excel accepts. Use INDEX/MATCH and VLOOKUP instead, and avoid volatile functions like INDIRECT and OFFSET.

What color convention do financial models use for inputs and formulas?▼

The standard convention uses blue text for hardcoded inputs, black for formulas, green for links to other sheets, red for links to other files, and yellow fill for key assumptions. Czech and Slovak finance teams read this convention fluently.