首先安装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');
});