CellRangeAddress(起始行,终止行,起始列,终止列)
public class LoopMergeStrategyQuestion extends AbstractRowWriteHandler { private List<ExcelCoordinate> Coordinates; public LoopMergeStrategyQuestion(List<ExcelCoordinate> Coordinates) { this.Coordinates=Coordinates; } public void afterRowDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Integer relativeRowIndex, Boolean isHead) { if (!isHead) { for(var Coordinate :Coordinates) { if (relativeRowIndex % Coordinate.getFirstRow() == 0) { CellRangeAddress cellRangeAddress = new CellRangeAddress(Coordinate.getFirstRow(), Coordinate.getLastRow(), Coordinate.getFirstCol(), Coordinate.getLastCol()); writeSheetHolder.getSheet().addMergedRegionUnsafe(cellRangeAddress); } } } } }