node处理xlsx

首先安装node-xlsx包

npm install node-xlsx

转换xlsx为node变量

var xlsx = require('node-xlsx');var data = xlsx.parse('test.xlsx');

转换node变量为xlsx

var xlsx = require('node-xlsx');var fs = require('fs');var data = [{  name: 'sheet1',  data: [    [      'A',      'B'    ],    [      '1',      '2'    ]  ]}, {  name: 'sheet2',  data: [    [      'A',      'B'    ],    [      '3',      '4'    ]  ]}]var buffer = xlsx.build(data);fs.writeFile('./resut.xlsx', buffer, function(err) {  if (err) throw err;  console.log('has finished');});