Welcome to the modern-xlsx wiki — comprehensive knowledge base for the library.

Current version: v0.7.1

• 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

• GitHub Repository
• npm Package
• Documentation Site
• Interactive Playground
• Issue Tracker

• 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