vue 导出exel文件

npm安装

npm install file-saver --save
npm install xlsx -s

使用

//html
<el-button type="primary" size="mini" @click="exportExcel">导出表格</el-button>

import * as XLSX from 'xlsx'
import { saveAs } from 'file-saver'

// 导出
    exportExcel(){
      const data = [
        [ '姓名','得分']
        ['张三',100],
        ['李四',90]
      ];
      
      const ws = XLSX.utils.aoa_to_sheet(data);
      const wb = XLSX.utils.book_new();
      XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
      const excelBuffer = XLSX.write(wb, { type: 'array', bookType: 'xlsx' });

      const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });
      saveAs(blob, 'demo.xlsx');
    }

效果

image.png