/**
* Created by 18468 on 2017/8/7.
*/
var fs = require('fs');
var xlsx = require('node-xlsx');
var list = xlsx.parse("./excel/" +"1.xlsx"); //读取excel
var datas=[];
var data=[1,2,3];
var data1=[4,5,6];
datas.push(data); //一行一行添加的 不是一列一列
datas.push(data1);
writeXls(datas);
function writeXls(datas) {
var buffer = xlsx.build([
{
name:'sheet1',
data:datas
}
]);
fs.writeFileSync('test1.xlsx',buffer,{'flag':'w'}); //生成excel
}
nodejs--node-xlsx模块读写excel
最新推荐文章于 2024-04-18 18:28:17 发布