[vue] XLSX 导出数据为excel

安装

npm install --save xlsx
1

import * as XLSX from 'xlsx';
1

exportArrayData: [
        ["序号", "英文名", "中文名"],
        ["1", "Good Morning", "早上好"],
        ["2", "Good Morning", "早上好"],
        ["3", "Good Morning", "早上好"],
        ["4", "Good Morning", "早上好"],
        ["5", "Good Morning", "早上好"]
      ]
1
2
3
4
5
6
7
8

exportArrayDataToExcel() {
     const wb = XLSX.utils.book_new(); // 创建工作簿
     const ws = XLSX.utils.aoa_to_sheet(this.exportArrayData); //  创建工作表
     const cols = [];
	// 设置列宽
     for (let i = 0; i < this.exportArrayData[0].length; i++) {
       cols.push({ wch: 15 });
     }
     ws['!cols'] = cols;
     XLSX.utils.book_append_sheet(wb, ws, 'exportArrayDataToExcel');
     // 导出Excel
     XLSX.writeFile(wb, '表格.xlsx');
   },
1
2
3
4
5
6
7
8
9
10
11
12
13

参考：

Vue+File saver+xlsx使用aoa_to_sheet导出数据为excel