WORKBOOKKITCHEN SINK FEATURE TOUR
BUILDER
createWorkbook()SHEETS
15OOXML PARTS
29 filesFEATURES
14DATASET
mediumA standalone playground kitchen sink with a feature map and one properly named sheet per major library primitive.
schema.ts
00 Feature MapA1:G16, frozen at C3
click a cell to inspect itfx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Kitchen Sink Feature Map
Track
Feature
Workbook Tab
What To Inspect
API Surface
Buffered
Streaming
Schema
Typed accessors
01 Typed Accessors
Typed row-shape accessors and derived values without cell coordinates.
accessor, dot paths, callbacks, defaultValue, autoWidth
Schema
Sub-row expansion
02 Sub Row Expansion
Nested line items expand into physical rows while parent cells merge.
array-valued accessors, merged parent cells
Formula
Formula DSL
03 Formula DSL
Column-ID formulas replace fragile A1 string math.
refs.column(), fx.round(), fx.safeDiv(), conditionalStyle
Formula
Summary rows
04 Summary Rows
Footer formulas and reducers align automatically across the schema.
summary.formula(), summary.cell(), summary.label()
Schema
Dynamic columns
05 Dynamic Columns
Runtime region columns still participate in typed totals.
dynamic(), typed schema context, refs.dynamic()
Renderer
Badges and checkboxes
06 Badges Checkboxes
Checkbox toggles feed live formulas and conditional styles; locked checkbox cells stay disabled on the protected sheet.
type: badge, type: checkbox, refs.column(), conditionalStyle, protection.locked
Renderer
Hyperlinks
07 Hyperlinks
External links, mailto links, and workbook-internal jumps.
type: hyperlink, target, tooltip
Renderer
Sparklines
08 Sparklines
Tiny trend charts driven by typed source columns.
type: sparkline, grouped sources, line/column/win-loss
Renderer
Images and media
09 Images Media
Embedded media and URL-backed IMAGE formulas side by side.
type: image, source: bytes, source: url
Workflow
Data validation
10 Data Validation
Native Excel validation rules are declared in the schema.
validation list, integer, date, prompt, error
Workflow
Protected inputs
11 Protected Inputs
End-user inputs stay editable while formulas remain protected.
sheet protection, locked cells, unlocked inputs, hidden formulas
Workbook
Native Excel table
12 Native Excel Table
Real Excel table objects with filter-aware totals.
mode: excel-table, autoFilter, totalsRow, table styles
Layout
Layout controls
13 Layout Controls
Multiple focused tables are composed on one sheet from one schema.
tablesPerRow, select.include, select.exclude, freezePane
Workbook
Charts and pivots
14 Charts Pivots
Native charts and a pivot table with its pivot chart, checked against the schema.
.chart(), refs.table().bar/line, .pivot(), refs.pivot().bar
Cell in the file