skills.rest
doable-me
doable-meOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Generates formula-driven Excel spreadsheets with structured sheets via exceljs.

39|14|Updated Mar 14, 2026
Search Tags:#formulas#spreadsheet#excel#xlsx#budget#financial model#exceljs
One-click install
npx skills add https://github.com/doable-me/Doable --skill xlsx-doable-me
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/doable-me/Doable/tree/main/mcp-servers/spreadsheet-builder/skills
Command: npx skills add https://github.com/doable-me/Doable --skill xlsx-doable-me

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires exceljs.

What problem does it solve? Creating spreadsheets by hand often leads to hardcoded totals, broken formulas, and placeholder data that make files unreliable for real financial or operational use. This Skill enforces disciplined spreadsheet design so every generated workbook uses live formulas, real data, and clean multi-sheet structure. ## Core Features & Use Cases - Formula-first generation: Totals, percent shares, growth rates, and lookups are written as Excel formulas (SUM, VLOOKUP) rather than precomputed numbers, so users can tweak inputs and watch results update. - Structured multi-sheet workbooks: Supports six spreadsheet kinds (data, budget, tracker, schedule, report, comparison) with conventions for summary sheets, assumptions sheets, frozen headers, and column widths. - Format and error compliance: Enforces currency, percent, date, and text formats while guaranteeing zero formula errors like #REF!, #DIV/0!, or #N/A. - Use Case: Ask for a quarterly budget and receive a workbook with category-by-period sheets, a totals row computed by =SUM formulas, a variance column, and a separate Assumptions sheet driving the calculations. ## Quick Start Ask the assistant to create a budget spreadsheet with real expense categories, formula-based totals, and a separate assumptions sheet using the xlsx skill.

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 spreadsheet with formulas instead of hardcoded values?▼

Write totals as =SUM(B2:B10), percent shares as =B2/$B$11 with anchored denominators, and lookups as =VLOOKUP against a separate Assumptions sheet. Never compute values in code and paste the result into the cell.

What spreadsheet structures does the xlsx skill support?▼

It supports six kinds: data, budget, tracker, schedule, report, and comparison. Each has a typical structure, such as categories by periods with totals for budgets, or options by criteria with scores for comparisons.

How should percentages and years be formatted in generated Excel files?▼

Store 0.18 in the cell with format percent so it renders as 18.0%, never the string "18%". For years, set format text on the column so 2024 is not treated as a number or prefixed with an apostrophe.

Why do generated spreadsheets show #REF! or #DIV/0! errors?▼

These errors come from broken range references or division by unset cells. The skill requires verifying that ranges include all data rows, sums match a manual spot-check, and no formula divides by an empty cell.

When should a workbook use multiple sheets instead of one?▼

Use multiple sheets when data is genuinely multi-faceted, such as separate Inputs, Calculations, and Outputs sheets. Keep one topic per sheet, put the summary view first, and add an Assumptions sheet for inputs driving multiple formulas.

Related Skills

Explore More Data & Analytics Skills→
Qiue-GQiue-G

xlsx

Process and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
Duzhenyang111Duzhenyang111

audit-xls

Validate Excel workbooks for formula errors and structural flaws using Python.

Community
Advanced
MuzeWinterMuzeWinter
1

validate-data

Validate analysis claims, calculations, visuals, and conclusions before stakeholder sharing.

Community
Advanced
lance-doniflance-donif

cloudbase-document-database-web-sdk

Execute database reads, writes, and real-time updates in web browsers via CloudBase.

Community
Intermediate