Skip to content

xlsx-kit@0.3.0

Choose a tag to compare

@github-actions github-actions released this 10 May 14:50
Immutable release. Only release title and notes can be modified.
f32c9f4

Minor Changes

  • #32 87a0051 Thanks @baseballyama! - Breaking: iterRows / iterValues (in xlsx-kit/worksheet) now
    iterate rectangularly over the populated bounding box rather than
    skipping empty rows and gaps. iterRows yields
    (Cell | undefined)[] (one entry per [minCol, maxCol] position);
    iterValues yields CellValue[] with null filling the gaps.

    Default extent switches from MAX_ROW/MAX_COL (the 1M × 16K sheet
    limit) to getMaxRow(ws) / getMaxCol(ws) (the populated bounding
    box). The IterRowsOptions.valuesOnly flag is removed — it was already
    unread.

    Migration:

    • Aggregation callers that want populated rows only:
      [...iterRows(ws)].filter((row) => row.some((c) => c !== undefined)).
    • Cell-by-cell streaming over populated cells only: keep using iterCells
      (unchanged).

    Closes #24.

  • #31 9297c46 Thanks @baseballyama! - Extend cellValueAsString (in xlsx-kit/cell) with optional
    dateFormat / emptyText overrides and add a sibling
    cellValueAsPrimitive that maps a CellValue to the most natural JS
    primitive (string | number | boolean | Date | null) without forcing a
    single target type. Closes #25.

  • #30 78d04fd Thanks @baseballyama! - Add workbookToBuffer to xlsx-kit/node. One-shot Node-flavored helper
    that returns a Buffer directly, paralleling the existing fromBuffer
    source. Closes #28.