vue+elementui系统利用Export2Excel.js将表格内容导出到excel,并设置表头文字水平垂直居中
IT树苗:
请问大佬,我的每个表格单元都有居中属性,但execl没居中
for (var i = 0; i < multiHeader.length; i++) {
dataInfo[arr[i]].s = style;
}
console.log(dataInfo);
for (var j = 0; j < multiHeader2.length; j++) {
dataInfo[arr[j]].s = style;
}
其中的B1
{
"v": "学员总消费次数",
"t": "s",
"s": {
"font": {
"color": {
"rgb": "000000"
},
"bold": true
},
"border": {
"color": {
"auto": 1
},
"top": {
"style": "thin"
},
"bottom": {
"style": "thin"
},
"left": {
"style": "thin"
},
"right": {
"style": "thin"
}
},
"alignment": {
"horizontal": "center",
"vertical": "center"
},
"fill": {
"fgColor": {
"rgb": "DCDFE6"
}
}
}
}
|