Sheetwrite
GitHub

CAPABILITY / FORMULAS

Ask the data. Watch the answer spill.

13 live formulas summarize 20,000 orders: group and pivot tables, statistics and distributions, a regression, finance and working days, a database query, LAMBDA helpers, and regex. Change the data and every answer recalculates.

Function names
Full engine
Orders
20,000
Live panels
13 formulas
Engine
@sheetwrite/formulas

Live analysis workbook

One edit. Every answer follows.

Loading the full formula engine…

A2 · Grouping · first value —

Revenue by region

One formula groups 20,000 orders by region, sums revenue, and adds a total row.

=GROUPBY(Orders!B1:B20000,Orders!G1:G20000,SUM,0,1)
Orders columns A–H: month, region, product, channel, units, price, revenue, order code.

Two engines, one API

Choose the formula engine your app needs.

@sheetwrite/wasm is the default engine. @sheetwrite/formulas is the same engine with the full function set. Select it once, before you create a Grid. Everything else stays the same.

See every supported function →
import { createGrid, initSheetwrite } from "@sheetwrite/core";
import * as formulas from "@sheetwrite/formulas";


await initSheetwrite(undefined, formulas);
const grid = createGrid(host, { workbook });
  • Grouping
  • Dynamic arrays
  • Statistics
  • Spill references
  • Regression
  • LAMBDA
  • Text and regex
  • Distributions
  • Finance and dates
  • Database