Recipes
Task-oriented recipes for ReoGrid Web. Each recipe is a short, copy-pasteable snippet that answers one question — "how do I do X?" — without forcing you to read an entire feature reference. Designed to work equally well as context for AI coding assistants.
Tables & Reports
- 🧾 Build an Invoice
Merged header, line items, currency formatting, and automatic totals.
- ⚡ Bulk Load from JSON
The fastest way to populate many rows from an array of objects.
- ∑ Running Total Column
A cumulative-sum column using a self-referencing formula pattern.
- 📈 Build a Pivot Table PRO
Summarize a source range into a live cross-tab written back into the grid.
Documents & Printing
Interactive Cells
- ☑️ Interactive Checklist PRO
A todo list built from checkbox cells with a live progress counter.
- 🎨 Colored Status Dropdown PRO
Dropdown cell + conditional formatting to color rows by status.
- ✅ Dropdown with Data Validation PRO
Attach a validated dropdown list plus numeric range rules that block bad input.
Data I/O
- 📥 Load XLSX from File Input
Wire up <input type="file"> to load an xlsx into the grid.
- 📤 Save Grid as XLSX PRO
Export the current worksheet as a downloadable xlsx file.
- 🔄 Convert XLSX to JSON
Load an xlsx and serialize it to lossless ReoGrid JSON — all client-side.
- 📊 Convert XLSX to Data Rows
Extract a clean array-of-objects from an xlsx for an API or database.