XLSX

stitchkit/xlsx turns rows into a workbook. It is evolving, it needs nothing beyond the zod the package already requires, and it runs wherever CompressionStream does: Bun, Node and a browser.

import { defineMoney } from 'stitchkit/primitives'
import { renderXlsx, XLSX_MEDIA_TYPE } from 'stitchkit/xlsx'

const rub = defineMoney('RUB')

const bytes = await renderXlsx({
  sheets: [
    {
      name: 'Orders',
      columns: [
        { key: 'title', header: 'Title', type: 'text' },
        { key: 'count', header: 'Count', type: 'number', format: '0.00' },
        { key: 'day', header: 'Day', type: 'date' },
        { key: 'at', header: 'Created', type: 'datetime', timeZone: 'Asia/Bangkok' },
        { key: 'total', header: 'Total', type: 'money', currency: 'RUB', scale: 2 },
        { key: 'paid', header: 'Paid', type: 'boolean' },
      ],
      rows: [
        {
          title: 'First order',
          count: '2.5',
          day: '2026-11-03',
          at: new Date(),
          total: rub.create('504182'),
          paid: true,
        },
      ],
    },
  ],
})

return new Response(bytes, {
  headers: {
    'content-type': XLSX_MEDIA_TYPE,
    'content-disposition': `attachment; filename*=UTF-8''${encodeURIComponent('Übersicht.xlsx')}`,
  },
})

A missing or null value leaves the cell empty. The first row holds the headers, stays frozen and carries a filter. The same input produces the same bytes on one runtime; Bun and Node compress differently.

Column types

type Cell value In the file
text string text, whatever it looks like: 007 keeps its zeros
number number, bigint or decimal string a number, with an optional Excel format
date YYYY-MM-DD a date serial; a calendar date has no time zone to get wrong
datetime Date or ISO instant with an offset the wall clock of the column’s timeZone to the second, since a cell stores no zone
money Money in the column’s currency a number with scale places and the currency in its format
boolean boolean a boolean

What it refuses

A value of the wrong type throws XlsxCellError naming the cell, such as sheet "Orders" B2: expected a number or a decimal string, instead of landing as a wrong cell.

Excel keeps numbers as doubles, so 15 significant digits are what survives. A decimal string or Money with more refuses rather than turning into a different amount. Keep such a value in a text column if it must stay exact and needs no arithmetic. Dates before 1900-03-01 refuse too: Excel counts a leap day that never happened, so its serials before it are off by one.

A wall clock cannot tell the two hours of a daylight-saving change apart: 05:30Z and 06:30Z on a New York autumn night are the same cell. Use UTC for a column whose order must survive that hour.

Text is never a formula

Cells are written as inline strings, so =HYPERLINK("x") from a user’s input is text a reader shows, and the file has no formula element at all. A cell that starts with =, +, - or @ also carries Excel’s quote prefix, so it stays text when a person edits that cell.

Limits

Everything is built in memory, up to Excel’s own 1 048 576 rows per sheet. There is no reading, no charts, no merged cells and no streaming: an application that needs them takes a library.