1.0.7 • Published 2 months ago
json2excel
!npm version
基于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