-
Notifications
You must be signed in to change notification settings - Fork 1
Home
ABCrimson edited this page Mar 4, 2026
·
21 revisions
Welcome to the modern-xlsx wiki — comprehensive knowledge base for the library.
Current version: v0.7.0
- Getting Started — Installation, setup, and your first spreadsheet
- Browser & CDN — Use directly in browsers via jsDelivr or unpkg
- API Reference — Complete API documentation
- Styling Guide — Fonts, fills, borders, alignment, number formats
- Examples — Common patterns and recipes
- Feature Comparison — modern-xlsx vs SheetJS (250 features compared)
- Performance — Benchmarks, optimization tips, and architecture
- Encryption Guide — Read and write encrypted XLSX files
- FAQ — Common questions and troubleshooting
- Migration from SheetJS — Side-by-side API comparison
- Migration from ExcelJS — ExcelJS → modern-xlsx patterns
- Architecture — Rust WASM + TypeScript hybrid design
- Changelog — Release history
-
Formula Engine — complete formula tokenizer, parser, evaluator, and 54 built-in Excel functions
-
evaluateFormula(formula, context)— evaluate any formula without Excel -
createDefaultFunctions()— 54 built-in functions (SUM, VLOOKUP, IF, etc.) -
parseFormula()→ AST →serializeFormula()— full roundtrip fidelity -
rewriteFormula()— adjust references on row/column insert/delete -
expandSharedFormula()— derive child formulas from master + offset -
resolveRef()/resolveRange()— resolve cell references to values
-
- Full Changelog
modern-xlsx v1.0.0
Getting Started
Guides
- Charts & Visualizations
- Formula Engine
- Table Layout Engine
- Tables & Print Layout
- Encryption
- Feature Comparison
Reference
Migration
Project