var XLSX = require('xlsx');
var _exports = {};
module.exports = _exports;
_exports.exportXls = function(data) {
var ws = {
s:{
"!row" : [{wpx: 67}]
}
};
ws['!cols']= [];
for(var n = 0; n != data[0].length; ++n){
ws['!cols'].push({
wpx: 170
});
}
var range = {
s : {
c : 10000000,
r : 10000000,
},
e : {
c : 0,
r : 0
}
};
for (var R = 0; R != data.length; ++R) {
for (var C = 0; C != data[R].length; ++C) {
if (range.s.r > R)
range.s.r = R;
if (range.s.c > C)
range.s.c = C;
if (range.e.r < R)
range.e.r = R;
if (range.e.c < C)
range.e.c = C;
v
nodeJS 利用xlsx导出插件导出excel文件 (可以设置excel单元格颜色/宽度)
最新推荐文章于 2024-03-04 11:51:17 发布