JS/TS电子表格引擎：SheetJS、ExcelJS、Hucre

SheetJS英文官网中文官网开源GitHub36.4K Star7.9K Fork。GitHub已不再维护查看源码新地址https://git.sheetjs.com/SheetJS/sheetjs中文文档。ExcelJS开源GitHub15.5K Star2.1K Fork。Hucre零依赖的 TypeScript 电子表格引擎支持读写多种电子表格格式。特点零依赖没有任何第三方依赖多格式支持XLSX、CSV、ODS、JSON、NDJSON、XML旧格式支持支持读取 XLSExcel 97-2003和 XLSB二进制格式纯 TypeScript原生 TypeScript 编写类型安全Tree Shaking按需导入减小打包体积流式处理支持大文件的流式读写跨平台Node.js、Deno、Bun、浏览器、Edge Runtime安全不使用 eval符合 CSP 要求对比特性hucreSheetJSCEExcelJSxlsx-js-style依赖数量00*90*包体积gzip4-129KB†~300KB~500KB~300KB原生ESM✅部分❌CJS部分TypeScript原生后加后加后加EdgeRuntime✅❌❌❌CSP兼容✅✅❌eval✅npm发布✅❌仅CDN停滞✅读写支持✅✅付费版$✅✅样式✅❌付费版$✅✅条件格式13种❌付费版$✅❌流式读写✅仅CSV✅仅CSVODS支持✅§✅❌✅往返保留✅部分部分部分迷你图✅❌❌❌解读SheetJS 已从 npm 下架必须从 CDN 安装取决于导入内容完全可 Tree ShakeODS 支持值、公式、合并和六种样式属性特性hucre(TS)openpyxl(Py)XlsxWriter(Py)rust_xlsxwriterApachePOI(Java)读取XLSX✅✅❌❌✅写入XLSX✅✅✅✅✅流式处理读写读写const_memoryconst_memorySXSSF写图表往返保留15种9种12种有限数据透视表读写骨架只读❌❌有限条件格式13种✅✅✅✅迷你图✅✅✅✅❌公式计算❌❌❌❌✅多格式XLSX/ODS/CSV仅XLSX仅XLSX仅XLSXXLS/XLSX零依赖✅lxml可选❌✅❌实战基于npm安装npm install hucre入门示例import{readXlsx,writeXlsx}fromhucre// 读取 XLSX 文件constworkbookawaitreadXlsx(buffer)console.log(workbook.sheets[0].rows)// 写入 XLSX 文件constxlsxawaitwriteXlsx({sheets:[{name:Products,columns:[{header:Name,key:name,width:25},{header:Price,key:price,width:12,numFmt:$#,##0.00},{header:Stock,key:stock,width:10},],data:[{name:Widget,price:9.99,stock:142},{name:Gadget,price:24.5,stock:87},],},],})Tree Shaking按需导入// 只使用XLSXimport{readXlsx,writeXlsx}fromhucre/xlsx// 只使用 CSV仅 ~2 KB gzippedimport{parseCsv,writeCsv}fromhucre/csv// 只使用ODSimport{readOds,writeOds}fromhucre/ods// 只使用JSON/NDJSONimport{parseJson,writeNdjson}fromhucre/json// 只使用XMLimport{readXml,writeXml}fromhucre/xml导入内容Gzipped体积CSV读写~3.7KBXLSX读取~34KBXLSX读写~68KB完整库~129KB支持多种数据类型import{readXlsx}fromhucre/xlsxconstwbawaitreadXlsx(uint8Array,{sheets:[0,Products],// 按索引或名称过滤工作表readStyles:true,// 解析单元格样式dateSystem:auto,// 自动检测日期系统1900/1904})for(constsheetofwb.sheets){console.log(sheet.name)// 工作表名称console.log(sheet.rows)// CellValue[][]console.log(sheet.merges)// MergeRange[]}基本写入import{writeXlsx}fromhucre/xlsxconstbufferawaitwriteXlsx({sheets:[{name:Report,columns:[{header:Date,key:date,width:15,numFmt:yyyy-mm-dd},{header:Revenue,key:revenue,width:15,numFmt:$#,##0.00},{header:Active,key:active,width:10},],data:[{date:newDate(2026-01-15),revenue:12500,active:true},{date:newDate(2026-01-16),revenue:8900,active:false},],freezePane:{rows:1},autoFilter:{range:A1:C3},},],defaultFont:{name:Calibri,size:11},})单元格级样式awaitwriteXlsx({sheets:[{name:Report,rows:[[{value:Region,style:{font:{bold:true}}},Revenue],[EU,{value:12500,style:{numFmt:$#,##0.00}}],[Total,{formula:SUM(B2:B2)}],],},],})根据内容自动计算最优列宽constbufferawaitwriteXlsx({sheets:[{name:Products,columns:[{header:Name,key:name,autoWidth:true},{header:Price,key:price,autoWidth:true,numFmt:$#,##0.00},{header:SKU,key:sku,autoWidth:true},],data:products,},],})数据验证constbufferawaitwriteXlsx({sheets:[{name:Sheet1,rows:[[Status,Quantity],[active,10],],dataValidations:[{type:list,values:[active,inactive,draft],range:A2:A100,showErrorMessage:true,errorTitle:Invalid,errorMessage:Pick from the list,},{type:whole,operator:between,formula1:0,formula2:1000,range:B2:B100,},],},],})超链接import{writeXlsx,link}fromhucre/xlsxawaitwriteXlsx({sheets:[{name:Summary,columns:[{header:Link,key:link},{header:ID,key:id},],data:[{link:link(Open,https://example.com/items/abc-123),id:abc-123},{link:{text:Open,hyperlink:https://example.com/items/def-456},id:def-456},],},],})提供了完整的流式 API可以处理超大文件而不占用过多内存。import{streamXlsxRows}fromhucre/xlsx// 逐行读取不一次性加载整个文件forawait(constrowofstreamXlsxRows(buffer)){console.log(row.index,row.values)}// 从网络流读取constresawaitfetch(https://example.com/huge.xlsx)forawait(constrowofstreamXlsxRows(res.body!)){console.log(row.index,row.values)}// 限制读取行数预览/采样forawait(constrowofstreamXlsxRows(buffer,{maxRows:100})){console.log(row.index,row.values)}// 读取指定范围forawait(constrowofstreamXlsxRows(buffer,{range:B2:D1000})){console.log(row.values)// 只包含 B/C/D 列}流式写入import{writeXlsxStream}fromhucre/xlsx// 生成器函数提供数据源function*rows(){for(leti0;i5_000_000;i)yield[i1,Math.random()]}// 流式写入内存占用恒定returnnewResponse(writeXlsxStream(rows(),{name:BigData,columns:[{header:ID},{header:Value}],freezePane:{rows:1},},),{headers:{content-type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,},},)行数writeXlsxStream内存XlsxStreamWriter内存300,00041 MB328 MB1,000,00067 MB1,037 MB3,000,00070 MB不可行支持读写加密的 XLSX 文件ECMA-376 Agile 加密import{writeXlsx,readXlsx,EncryptedFileError,DecryptionError}fromhucre// 写入加密文件constencryptedawaitwriteXlsx({sheets:[{name:Secret,rows:[[pin,1234]]}],encryption:{password:hunter2},})// 读取加密文件constwbawaitreadXlsx(encrypted,{password:hunter2})// 错误处理try{awaitreadXlsx(encrypted)}catch(e){if(einstanceofEncryptedFileError)console.log(需要密码)}XLSB二进制 Excel读取.xlsb文件比.xlsx更小更快import{readXlsb}fromhucreconstwbawaitreadXlsb(bytes)XLSExcel 97-2003读取传统的.xls文件import{readXls}fromhucreconstwbawaitreadXls(bytes)旧格式仅支持读取支持单元格值和合并单元格。往返保留Round-trip Preservation。打开、修改、保存文件而不丢失图表、宏等 hucre 不原生处理的功能import{openXlsx,saveXlsx}fromhucre/xlsxconstworkbookawaitopenXlsx(buffer)workbook.sheets[0].rows[0][0]Updated!constoutputawaitsaveXlsx(workbook)// 图表、VBA、主题都被保留区别readXlsx/writeXlsx创作路径从模型重建工作簿openXlsx/saveXlsx编辑路径保留 hucre 不建模的部分数据透视表import{writeXlsx}fromhucreconstxlsxawaitwriteXlsx({sheets:[{name:Data,rows:[[Region,Product,Revenue],[EU,A,100],[EU,B,50],[US,A,200],[US,B,75],],},{name:Pivot,pivotTables:[{name:SalesPivot,sourceSheet:Data,rows:[Region],columns:[Product],values:[{field:Revenue,function:sum}],},],},],})图表import{addChart,writeXlsx}fromhucreconstdashboard{name:Dashboard,rows:[[Quarter,Revenue,Forecast],[Q1,12000,11500],[Q2,15500,15000],[Q3,14000,14500],[Q4,17800,17200],],}addChart(dashboard,{type:column,title:Quarterly Revenue,series:[{name:Revenue,values:B2:B5,categories:A2:A5,color:1F77B4},{name:Forecast,values:C2:C5,categories:A2:A5,color:FF7F0E},],axes:{x:{title:Quarter},y:{title:Revenue (USD),numberFormat:{formatCode:$#,##0}},},legend:bottom,dataLabels:{showValue:true,position:outEnd},})awaitwriteXlsx({sheets:[dashboard]})