node读写excel文件

Node + node-xlsx 操作excel表格

node使用 node-xlse 简单读写excel表格

安装 node-xlsx

npm install --save node-xlsx

写入excel文件 .xls .xlsx

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

const data = [{
    name: 'Sheet1',
    data: [
        ['姓名','年龄','性别],
        ['张三','18','男'],
        ['小明','20','男']
    ]
}, {
    name: 'Sheet2',
    data: [
        ['学科','成绩'],
        ['语文','80'],
        ['数学','90']
    ]
}]

const res = xlsx.build(data)

fs.writeFile('demo.xlsx', res, err => {
    if (err) throw err;
    console.log('文件已被保存');
})

读取文件

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

const data = JSON.stringify(xlsx.parse(fs.readFileSync(`${__dirname}/demo.xlsx`)))
console.log(data);
// [{"name":"Sheet1","data":[["姓名","年龄","性别"],["张三","18","男"],["小明","20","男"]]},{"name":"Sheet2","data":[["学科","成绩"],["语文","80"],["数学","90"]]}]

github
博客地址