Overview
@helibeiqi/dsh-excel-kit
README / EN
Package documentation
Registry summary
dsh.pub verifies the pinned bundle contract, runtime facts, and distribution semantics. The complete README remains in the source repository.
Read the full README on GitHubLIMITATIONS
Known limitations
- **Read-only by design**: v0.1.0 strictly forbids writing or formatting. No `set_cell`, no style mutation. - SheetJS CE is a dependency for test cross-validation only; the production reader never calls `XLSX.readFile`. - `excel_filter` and `excel_pivot` reference columns by **header name** (first row). Empty header cells fall back to `colN` (1-based). - `mean`/`sum`/`min`/`max` operate on numeric values (numbers or numeric strings); non-numeric cells are ignored for numeric aggs. `count` counts non-empty values of the column within a group. - Group keys in `excel_pivot` join values with `|`; a value containing `|` may collide with a nested key (rare in practice). - Only the first sheet's `xlsx` (`.xlsx`, zip-based) format is supported — not legacy `.xls`, `.xlsb`, or password-encrypted files. - Streams are bounded, but `excel_describe` with default settings scans every row (that's the point — it is streaming, not free). ---