合并单元格
OnceAbsoluteMergeStrategy onceAbsoluteMergeStrategy2 = new OnceAbsoluteMergeStrategy(detail.size() + 1, detail.size() + 1, 0, 4);
设置好上面的以后就把他放入在.registerWriteHandler
属性中
OnceAbsoluteMergeStrategy onceAbsoluteMergeStrategy = new OnceAbsoluteMergeStrategy(excels.size() + 1, excels.size() + 1, 0, 4);
EasyExcel.write(out, DeptSummaryExcel.class)
.sheet("科室汇总查询")
.registerWriteHandler(new SimpleColumnWidthStyleStrategy(25))
.registerWriteHandler(ExcelUtil.writeCenterStyle())
.registerWriteHandler(onceAbsoluteMergeStrategy)
.doWrite(excels);
上面的代码中有个ExcelUtil.writeCenterStyle()
这里是设置的他的一些单元格样式
public static HorizontalCellStyleStrategy writeCenterStyle(){
WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
contentWriteCellStyle.setWrapped(true);
contentWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
contentWriteCellStyle.setBorderLeft(BorderStyle.THIN);
contentWriteCellStyle.setBorderTop(BorderStyle.THIN);
contentWriteCellStyle.setBorderRight(BorderStyle.THIN);
contentWriteCellStyle.setBorderBottom(BorderStyle.THIN);
WriteFont bodyWriteFont = new WriteFont();
bodyWriteFont.setFontHeightInPoints((short)12);
contentWriteCellStyle.setWriteFont(bodyWriteFont);
WriteCellStyle headWriteCellStyle = new WriteCellStyle();
headWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
WriteFont headWriteFont = new WriteFont();
headWriteFont.setFontHeightInPoints((short)15);
headWriteCellStyle.setWriteFont(headWriteFont);
return new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
}