vue导出excel，自定义多级表头高度

先看结果：

1、我的列表由于我的是有动态列的，所以下面的代码会对动态列进行判断处理：

导出结果：

2、直接贴代码，我对1、2、3行做了适配业务处理

导入依赖，没有的直接搜一下安装，然后导入即可

import { saveAs } from 'file-saver';

import * as ExcelJS from 'exceljs';

建议导入4.*的，如果导入报错，很可能是兼容问题，换一个版本

导出方法贴代码：

exportToExcel() {
            this.$nextTick(async () => {
            //const workbook = XLSX.utils.book_new();// new ExcelJS.Workbook();
            const workbook = new ExcelJS.Workbook();
            const worksheet = workbook.addWorksheet('Sheet1');
            // 设置多级表头
            if(this.data.checkbox4 == true){
                worksheet.mergeCells('A1:I1'); // 合并
            }else{
                worksheet.mergeCells('A1:H1'); // 合并
            }
            let cell =  worksheet.getCell('E1');
            cell.value = '明细分类账';
            cell.alignment = { horizontal: 'center', vertical: 'middle' };
            cell.font = { size: 24 }; // 设置字体大小

            worksheet.mergeCells('A2:C2'); // 合并
            const datestr = this.getDeatilDate();
            cell =  worksheet.getCell('A2');
            cell.value = datestr;
            cell.alignment = { horizontal: 'center', vertical: 'middle',wrapText: true };//wrapText: true允许换行

            if(this.data.checkbox4 == true){
                worksheet.mergeCells('E2:I2'); // 合并
            }else{
                worksheet.mergeCells('E2:H2'); // 合并
            }
            const dm = this.getDetailShow();
            cell =  worksheet.getCell('G2');
            cell.value = dm;
            cell.alignment = { horizontal: 'center', vertical: 'middle' };

            worksheet.mergeCells('A3:A4'); // 合并第一列的3、4行
            const cell1 =  worksheet.getCell('A3');
            cell1.value = '凭证日期';
            cell1.alignment = { horizontal: 'center', vertical: 'middle' };

            worksheet.mergeCells('B3:B4'); // 合并
            const cell2 =  worksheet.getCell('B3');
            cell2.value = '凭证字号';
            cell2.alignment = { horizontal: 'center', vertical: 'middle' };


            worksheet.mergeCells('C3:C4'); // 合并
            const cell3 =  worksheet.getCell('C3');
            cell3.value = '摘要';
            cell3.alignment = { horizontal: 'center', vertical: 'middle' };


            worksheet.mergeCells('D3:D4'); // 合并
            const cell4 =  worksheet.getCell('D3');
            cell4.value = '对方科目';
            cell4.alignment = { horizontal: 'center', vertical: 'middle' };

            worksheet.mergeCells('E3:E4'); // 合并
            const cell5 =  worksheet.getCell('E3');
            cell5.value = '借方';
            cell5.alignment = { horizontal: 'center', vertical: 'middle' };


            worksheet.mergeCells('F3:F4'); // 合并
            const cell6 =  worksheet.getCell('F3');
            cell6.value = '贷方';
            cell6.alignment = { horizontal: 'center', vertical: 'middle' };


            if(this.data.checkbox4 == true){
                worksheet.mergeCells('G3:G4'); // 合并
                const cell7 =  worksheet.getCell('G3');
                cell7.value = '实际发生额';
                cell7.alignment = { horizontal: 'center', vertical: 'middle' };

                worksheet.mergeCells('H3:I3'); // 合并
                const cell8 =  worksheet.getCell('H3');
                cell8.value = '余额';
                cell8.alignment = { horizontal: 'center', vertical: 'middle' };

                const cell9 =  worksheet.getCell('H4');
                cell9.value = '方向';
                cell9.alignment = { horizontal: 'center', vertical: 'middle' };

                const cell10 =  worksheet.getCell('I4');
                cell10.value = '金额';
                cell10.alignment = { horizontal: 'center', vertical: 'middle' };
            }else {
                worksheet.mergeCells('G3:H3'); // 合并
                worksheet.getCell('G3').value = '余额';
                const cell8 =  worksheet.getCell('H3');
                cell8.value = '余额';
                cell8.alignment = { horizontal: 'center', vertical: 'middle' };

                const cell9 =  worksheet.getCell('G4');
                cell9.value = '方向';
                cell9.alignment = { horizontal: 'center', vertical: 'middle' };

                const cell10 =  worksheet.getCell('H4');
                cell10.value = '金额';
                cell10.alignment = { horizontal: 'center', vertical: 'middle' };
                
            }
            
            // 添加数据行
            if(this.data.checkbox4 == true){
                this.tableData.forEach(row => {
                    const currow = worksheet.addRow([
                        row.billdate,
                        row.credname,
                        row.brief,
                        row.targetSubjectName,
                        row.debit,
                        row.credit,
                        (row.debit == null ? 0 : row.debit) - (row.credit == null ? 0 : row.credit),
                        row.todebit,
                        row.lastMoney
                    ]);
                    // 设置整行内容居中对齐
                    currow.eachCell({ includeEmpty: true }, (cell) => {
                        cell.alignment = { horizontal: 'center', vertical: 'middle' };
                    });
                });

            }else {
                this.tableData.forEach(row => {
                  const currow = worksheet.addRow([
                        row.billdate,
                        row.credname,
                        row.brief,
                        row.targetSubjectName,
                        row.debit,
                        row.credit,
                        row.todebit,
                        row.lastMoney
                    ]);
                    // 设置整行内容居中对齐
                    currow.eachCell({ includeEmpty: true }, (cell) => {
                        cell.alignment = { horizontal: 'center', vertical: 'middle' };
                    });
                });
            }
            // 获取最后一行的行号
            const lastRowNumber = worksheet.rowCount;

            // 获取当前日期
            const currentDate = new Date();
            // 格式化日期为 YYYY-MM-DD
            const formattedDate = currentDate.toISOString().split('T')[0]; // 使用toISOString方法并截取日期部分
            worksheet.mergeCells('A'+(lastRowNumber+1)+':C'+(lastRowNumber+1)); // 合并
            cell =  worksheet.getCell('A'+(lastRowNumber+1));
            cell.value = '操作员：'+this.opname;
            cell.alignment = { horizontal: 'center', vertical: 'middle' };

            worksheet.mergeCells('E'+(lastRowNumber+1)+':H'+(lastRowNumber+1)); // 合并
            cell =  worksheet.getCell('E'+(lastRowNumber+1));
            cell.value = '打印时间：'+formattedDate;
            cell.alignment = { horizontal: 'center', vertical: 'middle' };


            // // 设置列宽、由于我上面设置了多级表头，这里的就不需要设置表头和宽度了
            // worksheet.columns = [
            // { header: '凭证日期', key: 'billdate', width: 15,  },
            // { header: '凭证字号', key: 'credname', width: 15,  },
            // { header: '摘要', key: 'brief', width: 30, },
            // { header: '对方科目', key: 'targetSubjectName', },
            // { header: '借方', key: 'debit', width: 15,  },
            // { header: '贷方', key: 'credit', width: 15, },
            // { header: '实际发生额', key: 'happenMoney', width: 15, },
            // { header: '余额', key: 'hadmoney', width: 15, },
            // ];
            // 设置特定行的高度（例如第2行）
            const rowNumber = 2; // 行号从1开始
            const rowHeight = 80; // 设置为80
            const row = worksheet.getRow(rowNumber);
            row.height = rowHeight;
            // 导出 Excel 文件
            const buffer = await workbook.xlsx.writeBuffer();
            saveAs(new Blob([buffer]), '明细分类账.xlsx');
            });
        },