easyexcel导出中自定义合并单元格,通过重写AbstractRowWriteHandler
爱妮0*0:
大佬写的太哇塞了,但是在使用的时候需要判断一下,否测会
报空指针异常
[code=java]
if (relativeRowIndex != null && cellRange != null && cellRange.getFirstRow() !=0 && writeSheetHolder != null && writeSheetHolder.getSheet() != null) {
if (relativeRowIndex % cellRange.getFirstRow() == 0) {
CellRangeAddress cellRangeAddress = new CellRangeAddress(cellRange.getFirstRow(), cellRange.getLastRow(), cellRange.getFirstCol(), cellRange.getLastCol());
writeSheetHolder.getSheet().addMergedRegionUnsafe(cellRangeAddress);
}
}
[/code]
|