Workbook Builder

Overview

The two workbook builders — createWorkbook() for buffered exports and createWorkbookStream() for streaming.

typed-xlsx now ships with two workbook builders:

createWorkbook() for buffered exports
createWorkbookStream() for commit-based exports

Buffered

import { createWorkbook
 } from "@chronicstone/typed-xlsx";

const workbook
 = createWorkbook
();

Stream

import { createWorkbookStream
 } from "@chronicstone/typed-xlsx";

const workbook
 = createWorkbookStream
({
  tempStorage
: "file",
  memoryProfile
: "low-memory",
});

Use the buffered builder when you want the most natural workbook composition API. Use the stream builder when your dataset is too large to materialize comfortably in memory and you want to commit rows in batches. In stream mode, memoryProfile and strings let you bias the writer toward lower memory usage or smaller final files.

Column Groups

Generating columns dynamically from runtime context using .group().

Sheets

Creating sheets with layout options, freeze panes, and right-to-left direction.