styled-exceljs is a fork of the original SheetJS Community Edition source
code. This fork keeps the SheetJS-compatible workbook and worksheet model, then
adds browser-oriented visual fidelity extensions for styles, dimensions,
drawings, charts, merge validation, and HTML rendering.
中文说明：styled-exceljs 基于 SheetJS Community Edition 原始代码 fork
并继续增强，保持 SheetJS 兼容的数据模型，同时扩展样式、行列尺寸、图片绘图、
图表、合并校验和浏览器 HTML 渲染能力。
The SheetJS Community Edition offers battle-tested open-source solutions for extracting useful data from almost any complex spreadsheet and generating new spreadsheets that will work with legacy and modern software alike.
SheetJS Pro offers solutions beyond data processing: Edit complex templates with ease; let out your inner Picasso with styling; make custom sheets with images/graphs/PivotTables; evaluate formula expressions and port calculations to web apps; automate common spreadsheet tasks, and much more!
publish.yml checks out the exact stable release tag, runs the security,
table-style and CFB regressions, builds the package, and publishes with npm
provenance. The npm trusted publisher must bind styled-exceljs to
flyfish-dev/styled-exceljs and publish.yml; the workflow itself does not
create that npm permission. Original SheetJS authorship and licensing remain
unchanged.
Manual dispatch defaults to a dry run. Reruns skip an existing version only when its registry SHA-512 matches the packed bytes. Authentication failures, different bytes and uncertain writes stop instead of being silently retried.
The maintained CI matrix uses Node 22/24/26, Bun and Deno 2. Node 24 runs the
full official corpus in both CJS and ESM; the other runtimes run the core
corpus. A runtime assertion prevents a Bun/Deno command from silently falling
back to Node. The test archive is pinned to SHA-256
a786d4f1a80adf9447997b6f3b30b2593c776c27e0b075e3971627c17205f220
and cached once before the matrix. Moving external SVN checkouts and obsolete
Node 0.x/io.js/Deno 1 harnesses are no longer release gates. Historical engine
metadata is not evidence of a fresh test on those retired runtimes.
To repeat the full corpus locally after installing the verified archive and
building the source, run FMTS=full STYLED_TEST_RUNTIME=node npm run test:corpus.
Pending tests remain visible and are not counted as passing.
Install this build from the public npm registry:
npm install styled-exceljsThis build extends the SheetJS worksheet model for browser-oriented rendering of XLSX/XLS workbooks. The default read path stays lightweight and compatible. Visual metadata is exposed when explicit options are enabled:
const wb = XLSX.read(data, {
type: "buffer",
cellStyles: true,
browserPixels: true,
charts: true,
drawings: true,
validateMerges: true
});
const ws = wb.Sheets[wb.SheetNames[0]];
const html = XLSX.utils.sheet_to_html(ws, {
cellStyles: true,
browserPixels: true,
autoFit: true,
charts: true,
drawings: true
});The following public worksheet fields are populated when requested:
cell.s: resolved style object withfont,fill,border,alignment,protection,numFmt,fgColor, andbgColor.ws["!cols"]/ws["!rows"]: column widths and row heights including browser pixel fields (wpx,hpx) and default row/column styles.ws["!mergeErrors"]: non-fatal merge validation issues in tolerant reads.ws["!drawings"]: parsed images, shapes, anchors, raw fallback records.ws["!charts"]and chartsheetws["!chart"]: normalized chart models used by HTML SVG rendering.XLSX.utils.auto_fit_columns(ws, opts): browser-measured best-fit column widths with wrap, overflow, shrink-to-fit, and merge-span handling.
XLSX.utils.validate_merges(ws, opts) validates merge ranges and reports
duplicate, overlapping, malformed, or out-of-bounds ranges. Passing
{WTF:true} or reading with {validateMerges:true} throws on malformed merges.
See the visual fidelity guide for the full data structure reference and release notes for unsupported fallback behavior.
从官方 npm registry 安装：
npm install styled-exceljs这个版本面向浏览器预览和报表渲染扩展了 XLSX / XLS 的视觉读取能力。
默认读取路径仍然保持轻量和兼容；只有显式开启 cellStyles、
browserPixels、autoFit、charts、drawings 和 validateMerges 等选项时，
才会解析完整样式、浏览器像素尺寸、自动列宽、图片、绘图、图表和合并单元格
校验结果。
常用入口如下：
cell.s：解析后的完整样式对象，包括字体、填充、边框、对齐、保护和数字格式。ws["!cols"]/ws["!rows"]：列宽、行高、隐藏状态、层级和浏览器像素值。ws["!drawings"]：图片、形状、锚点和复杂绘图的 raw fallback。ws["!charts"]/ws["!chart"]：工作表嵌入图表和图表工作表模型，可用于 SVG 渲染。XLSX.utils.validate_merges(ws, opts)：检查非法、重复、重叠和越界的合并单元格。XLSX.utils.auto_fit_columns(ws, opts)：结合浏览器文字测量、换行、溢出、 收缩适应和合并跨度计算最优列宽。
完整中文数据结构、选项说明和渲染行为请参考 中文视觉保真指南。
Run npm test with the official SheetJS fixture corpus in the ignored
test_files/ directory. The Makefile's source is
test_files.zip. The 2024-07-17
archive used for the 0.21.5 candidate has SHA-256
a786d4f1a80adf9447997b6f3b30b2593c776c27e0b075e3971627c17205f220.
Do not commit the corpus or private customer files.
The candidate run passed 74,699 tests with four pending tests. Four legacy column-width assertions also failed on unchanged 0.21.4: they assumed MDW=6 instead of that version's stable MDW=7 fallback. The updated assertions keep native XLS/XLSX widths distinct from XLML pixel widths and SYLK character widths; the parser's measured values are unchanged. MiniFAT tests cover the failure mechanism with generated files, not the unavailable private reporter file.
回归测试需要官方语料；语料和客户文件不能提交。0.21.5 候选版全量测试为 74,699 项通过、4 项待启用。四项旧列宽断言在未修改的 0.21.4 上同样失败， 本次只更新断言以符合该版已有的 MDW=7 行为，不修改解析结果来迎合测试。 MiniFAT 合成文件证明了故障机制，不代表已验证尚未提供的私有原文件。
-
https://oss.sheetjs.com/notes/: File Format Notes
-
ssf: Format data using ECMA-376 spreadsheet format codes -
xlsx-cli: NodeJS command-line tool for processing files -
cfb: Container (OLE/ZIP) file processing library -
codepage: Legacy text encodings for XLS and other legacy spreadsheet formats
Please consult the attached LICENSE file for details. All rights not explicitly granted by the Apache 2.0 License are reserved by the Original Author.