Home

modern-xlsx Wiki

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

Current version: v0.5.1

Quick Links

• 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
• FAQ — Common questions and troubleshooting

Migration Guides

• Migration from SheetJS — Side-by-side API comparison
• Migration from ExcelJS — ExcelJS → modern-xlsx patterns

Project

• Architecture — Rust WASM + TypeScript hybrid design
• Changelog — Release history

External Links

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

New in v0.5.0

• Excel Tables (ListObjects) — full OOXML table read/write with 60 built-in styles, CRUD API
• Headers & Footers — HeaderFooterBuilder fluent API with formatting codes
• Row/Column Grouping — outline levels 0-7 with collapse/expand support
• Print Titles & Areas — repeating rows/columns and print area configuration
• Parity Sprint — closed 7 categories where SheetJS previously beat or tied modern-xlsx
  • encodeRow(), decodeRow(), splitCellRef() — full cell reference utility parity
  • ws.usedRange, ws.tabColor — worksheet computed range and tab color
  • cell.numberFormat, cell.dateValue — cell format resolution and date detection
  • formatCellRich(), loadFormat(), conditional sections, color codes — advanced number formatting
  • sheetToTxt(), sheetToFormulae() — sheet conversion utilities
  • dynamicArray flag, stub cell type, 6 new document properties
• Full Changelog