excel.js

1.制作excel表格

var Excel = require('exceljs');


function makeExcel(result) {
    var workbook = new Excel.Workbook();//创建一个文件
    workbook.creator = 'BertaData-API';
    workbook.lastModifiedBy = 'BertaData-API';
    workbook.created = new Date();
    workbook.modified = new Date();

    var sheet = workbook.addWorksheet('预警名单');//创建一个工作组
//创建列
    sheet.columns = [
        {header: '用户名', key: 'userName', width: 25},
        {header: '方法名', key: 'methodName', width: 25},
        {header: '到期时间', key: 'expiredDate', width: 25},
    ];
    sheet.addRows(result);//创建行
    var filename = 'Api用户接口到期名单.xlsx';
    workbook.xlsx.writeFile(filename).then(function () {
        console.log('success');
    }, function (err) {
        console.log(err);
    });
}