xlsx的使用

2024年01月27日约182字预计需要1分钟

导出excel

import * as XLSX from 'xlsx';

const fileName = 'test';
let data = [
    [
        ctx.__('test1'),
        ctx.__('test2'),
        ctx.__('test3')
    ]
];
const workbook = XLSX.utils.book_new();
const worksheet = XLSX.utils.json_to_sheet(data, { skipHeader: true });
XLSX.utils.book_append_sheet(workbook, worksheet, 'sheetName');
// eggjs导出excel
this.ctx.set('Content-Type', 'application/vnd.openxmlformats');
this.ctx.set(
    'Content-Disposition',
    "attachment;filename*=UTF-8' '" + encodeURIComponent(fileName) + '.xlsx',
);
this.ctx.body = await XLSX.write(workbook, {
    bookType: 'xlsx',
    type: 'buffer',
});

设置单元格格式

使用xlsx-style

import xlsxStyle from '`xlsx-style`';
import * as XLSX from 'xlsx';

/**使用XLSX导出excel的workbook**/
const workbook = XLSX.utils.book_new();
const worksheet = XLSX.utils.json_to_sheet([['test']], { skipHeader: true });
XLSX.utils.book_append_sheet(workbook, worksheet, 'sheetName');

// 使用xlsxStyle写出excel
this.ctx.body = await xlsxStyle.write(workbook, {
    bookType: 'xlsx',
    type: 'buffer',
});