github地址 :https://github.com/mgcrea/node-xlsx
npm install node-xlsx
导入的例子:
var xlsx = require('node-xlsx');
var obj = xlsx.parse(__dirname + '/myFile.xlsx'); // parses a file
var obj = xlsx.parse(fs.readFileSync(__dirname + '/myFile.xlsx')); // parses a buffer
导出的例子:
var xlsx = require('node-xlsx');
var data = [[1,2,3],[true, false, null, 'sheetjs'],['foo','bar',new Date('2014-02-19T14:30Z'), '0.3'], ['baz', null, 'qux']];
var buffer = xlsx.build([{name: "mySheetName", data: data}]); // returns a buffer
res.type('application/vnd.openxmlformats').set('Content-Disposition', 'attachment; filename=eg.xlsx');
res.end(buffer, 'binary');