1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| import Excel from '@/libs/excel'
|
| /**
| * 导出数据到xlsx文件
| * @param {*} vm
| * @param {*} btn
| */
| export const exportExcel = async (vm, datas) => {
| const columns = vm.columns.filter(c => c.key != 'index').map(c => ({
| header: c.title,
| key: c.key,
| width: (c.width || 25) / 8,
| style: {
| alignment: {
| horizontal: c.TextAlign || 'left'
| }
| }
| }));
| let frozenColumnId = 1
| const excel = new Excel();
| excel.exportExcel({
| name: '导出文件',
| datas,
| columns,
| frozenColumnId,
| })
| }
|
|