Documentation

Install the package and set up your first grid in React, Vue, or plain JavaScript.

Overview of all features and edition comparison (Lite vs Pro).

Reading and writing values, CellHandle API, bulk loading.

Fonts, colors, alignment, text wrapping.

Excel-compatible format codes for numbers, currency, dates.

Checkbox, dropdown, progress bar, rating, sparkline.

Cell and range border styles.

Merging and unmerging cells.

Auto-style cells based on value thresholds, formulas, or text matches.

Contextual tooltips for input hints, validation errors, and custom messages.

Single-author notes with a red corner marker and hover bubble; xlsx read + JSON round-trip.

A workbook of N sheets with a tab bar, per-sheet undo, whole-workbook I/O, and cross-sheet formulas.

Resizing, insert/delete, show/hide, auto-fit.

Pin header rows and columns while scrolling.

Column sorting and auto-filter dropdowns.

Row/column outlining with collapse/expand.

Cross-tab a source range with row/column fields, aggregated measures, filters, and grand totals.

Turn a range into a banded Excel table that re-flows as rows are added; full xlsx round-trip.

Dropdown lists, numeric/date/length rules, and custom formulas with input prompts and alerts.

Design a report with {{token}} cells and repeating detail bands, then bind data to expand it.

Cell selection, keyboard navigation, events.

Drag the fill handle to extend values, dates, and formulas — Excel-style fill patterns.

Excel-compatible formulas with 109 built-in functions and a color-coded reference editor.

Name a cell or range and use it in formulas — workbook/sheet scope, xlsx round-trip, #REF! handling.

Load and save Excel files.

Lossless native JSON to save/restore a full workbook — and convert xlsx to JSON.

Copy, cut, and paste operations.

Render a worksheet to a real vector PDF with an embedded font; honors the page-break preview.

Paper size, margins, scale, and an Excel-style page-break preview with manual breaks.

Quick print via the browser's native print dialog.

Display images from xlsx files.

Undo and redo operations.

Sheet protection and cell locking.

Smooth animation on cell value changes.

createReogrid() options, grid line visibility, size, and rendering control.