Streaming readers & writers

Open an xlsx for read-only streaming access.

Cell values match what loadWorkbook reports for the same bytes, rich text included. Where the two differ is in how much they tolerate: this reader reports a cell as empty for a t="s" index with no shared string behind it and for a t="b" value outside xsd:boolean, both of which loadWorkbook rejects. A pass over a sheet too large to model should not lose every row after one corrupt cell. A malformed number still throws, because a null there could not be told apart from an empty cell.

function loadWorkbookStream(source: XlsxSource, opts?: LoadWorkbookStreamOptions): Promise<ReadOnlyWorkbook>

Parameters

Returns

Promise<ReadOnlyWorkbook>

Open a workbook for streaming write-only output.

function createWriteOnlyWorkbook(sink: XlsxSink, opts?: WriteOnlyOptions): Promise<WriteOnlyWorkbook>

Parameters

Returns

Promise<WriteOnlyWorkbook>