json2excel

[!npm version] (https://img.shields.io/badge/npm-1.0.0-brightgreen) 基于xlsx xlsx-style 实现 配置话表格导出excel， 自定义动态多级表头，数据合并（支持自定基准列）、单元格字体颜色、单元格格式、宽度、数据自动分页

install

npm install json2excel

for example

option = { fileName: '效期商品预警', datumKey:"stockSkuName", header: [ { prop: '', title: '效期商品预警', children: [ { prop: "index", title: "编号", valueType: 'n', numFmt: $numFmt.numInt }, { prop: "stockSkuName", title: "物料SKU名称", merge: true }, { prop: "stockSkuCode", title: "物料SKU编码", merge: true }, { prop: "stockSkuBarCode", title: "物料SKU条形码", }, { prop: "producedBatchCode", title: "生产批次", valueType: 'n', }, { prop: "libraryName", title: "仓库", }, { prop: "producedTime", title: "生产日期", }, { prop: "shelfLife", title: "保质期", }, { prop: "expirationTime", title: "过期日期", }, { prop: "shelfLifeReminderDays", title: "保质期提醒天数", }, { prop: "shelfLifeLockdownDays", title: "保质期禁售天数", }, { prop: "expirationDays", title: "剩余天数", colorFun:(v,i)=>{ let num = i.shelfLifeReminderDays.replace('天','').replace('月','') if (i.expiryUnit){ // 单位为月时 num = num*30 } return v <= num?"ff0000":"000000" }, valueType: 'n', numFmt: $numFmt.numInt }, { prop: "stockSkuType", title: "库存属性", }, { prop: "entityStock", title: "实物库存", valueType: 'n', numFmt: $numFmt.numInt }, { prop: "useStock", title: "可用库存", valueType: 'n', numFmt: $numFmt.numInt }, { prop: "lockStock", title: "锁定库存", valueType: 'n', numFmt: $numFmt.numInt }, { prop: "freezerStock", title: "冻结库存", valueType: 'n', numFmt: $numFmt.numInt }, { prop: "dyingState", title: "临期状态", colorFun:(v)=>{ let str = '' switch (v) { case "正常": str = '67c23a'; break; case "临期": str = 'ff0000'; break; case "禁售": str = 'BA1000'; break; case "已处理": str = 'CC0BD4'; break; case "已售完": str = '000000'; break; } return str } }, ] } ], dataSource }

for example