Home

Jump to bottom

ABCrimson edited this page Mar 6, 2026 · 21 revisions

modern-xlsx Wiki

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

Current version: v0.9.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
Encryption Guide — Read and write encrypted XLSX files
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

New in v0.9.1

35-Point Performance & Maintainability Overhaul — ryu float formatting, byte-level JSON escaping, zero-alloc relationship constants, module splits for worksheet.rs (7K lines → 4 files) and charts.rs (5K lines → 4 files), O(1) sheet name cache, discriminated union Worker messages, cargo-audit + npm audit CI scanning, matrix testing (Node 24+25 × ubuntu+windows)
Full Changelog

New in v0.9.0

Pivot Tables (read-only) — full OOXML pivot table, cache definition, and cache records parsing
- ws.pivotTables read-only API
Threaded Comments (read + write) — modern threaded comment threads with person management
- ws.addThreadedComment() and ws.replyToComment() APIs
Slicers (read-only) — slicer definitions and caches for pivot table filtering
Timelines (read-only) — timeline definitions and caches for date-based pivot filtering
CLI Tool — modern-xlsx info and modern-xlsx convert commands
Feature-Gated WASM — encryption and charts Cargo features for smaller bundles
ModernXlsxError — structured error handling with .code property
Performance — 4-8x faster bulk read/write, XML buffer pre-allocation
Full Changelog