nodejs写excel

1、安装第三方库

npm install node-xlsx --save

2、实现代码：

var fs = require('fs');
var xlsx = require('node-xlsx');

var buffer = xlsx.build({worksheets: [
  {"name":"mySheetName", "data":[
    ["A1", "B1"],
    [
      {"value":"A2","formatCode":"General"},
      {"value":"B2","formatCode":"General"}
    ]
  ]}
]});
fs.writeFileSync("./myFile.xlsx, buffer, 'binary')