VUE3+TYPESCRIPT实现表格导出excel

安装依赖

yarn add excel

封装

// exportToExcel.ts
import * as XLSX from 'xlsx';
const EXCEL_TYPE = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8';
const EXCEL_EXTENSION = '.xlsx';
export class ExcelService {
    constructor() { }
    static toExportFileName(excelFileName: string): string {
        return `${excelFileName}-${new Date().getTime()}.xlsx`;
    }
    public exportAsExcelFile(json: any[], excelFileName: string): void {
        const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);
        const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] };
        XLSX.writeFile(workbook, ExcelService.toExportFileName(excelFileName));
    }
}

使用

import { ExcelService } from "../../utils/exportToExcel";

const json = [{ name: "tom", age: 18 },{ name: "army", age: 16 }];
const s = new ExcelService();
s.exportAsExcelFile(json, "导出名称");