hutool ExcelUtil导出复杂表头excel

左手的ㄟ右手 2024-03-27 09:46 224阅读 0赞

### 效果图 ###

![在这里插入图片描述][2e3f0851ca0d4e1e9a01ec753987025f.png]

### 代码 ###

导入hutool依赖省略…

public static void main(String[] args) {
        ExcelWriter writer = null;
    
        try {
    
            writer = ExcelUtil.getWriter(true);
    
            // 标题
            writer.merge(0, 1, 0, 0, "序号", true);
            writer.merge(0, 1, 1, 1, "合同编号", true);
            writer.merge(0, 1, 2, 2, "合同名称", true);
            writer.merge(0, 1, 3, 3, "承包商", true);
            writer.merge(0, 0, 4, 5, "合同投资", true);
            writer.merge(0, 1, 6, 6, "动态投资", true);
            writer.merge(0, 1, 7, 7, "估算投资", true);
            writer.merge(0, 1, 8, 8, "概算投资", true);
            writer.merge(0, 0, 9, 10, "工程预算", true);
            writer.merge(0, 0, 11, 12, "工程结(决)算", true);
            writer.merge(0, 0, 13, 14, "工程审计金额", true);
            writer.writeCellValue(4, 1, "总投资");
            // 设置单元格为表头默认样式,不设置当前单元格样式会与表头不一致
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 4, 1);
            writer.writeCellValue(5, 1, "暂定金额");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 5, 1);
            writer.writeCellValue(9, 1, "工程预算");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 9, 1);
            writer.writeCellValue(10, 1, "招标控制价");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 10, 1);
            writer.writeCellValue(11, 1, "结算金额");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 11, 1);
            writer.writeCellValue(12, 1, "决算金额");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 12, 1);
            writer.writeCellValue(13, 1, "结算审计");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 13, 1);
            writer.writeCellValue(14, 1, "决算审计");
            writer.setStyle(StyleUtil.createHeadCellStyle(writer.getWorkbook()), 14, 1);
    
            writer.passCurrentRow();
            writer.passCurrentRow();
            List<String> row1 = CollUtil.newArrayList("一","","建安投资","承包商1","23","30","54.2","23","22","33","124","203","345","55","5555");
            List<String> row2 = CollUtil.newArrayList("二","","建安投资","承包商1","23","30","54.2","23","22","33","124","203","345","55","5555");
            List<List<String>> rows2 = CollUtil.newArrayList(row1,row2);
            writer.write(rows2, false);
            // 写出流
            writer.flush(new FileOutputStream(new File("d:/复杂表头.xlsx")));
    
        } catch (Exception e) {
    
        } finally {
            if (writer != null) {
                writer.close();
            }
        }
    }

[2e3f0851ca0d4e1e9a01ec753987025f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/ff60dfafd8e84cf08c0abdb09c032c62.png