EasyExcel合并单元格

最新推荐文章于 2025-07-10 16:39:07 发布

原创最新推荐文章于 2025-07-10 16:39:07 发布 · 636 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #excel #开发语言

该文章介绍了一个名为`ExcelFillCellMergePrevCol`的类，它是`CellWriteHandler`的实现，用于处理EasyExcel写操作时的单元格合并。通过维护一个`mergeInfo`映射表来存储合并信息，类提供了添加合并范围和实际执行合并的方法。在`afterCellDispose`方法中检查并执行合并操作，将指定行和列的单元格与之前若干列合并。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


 
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.metadata.data.CellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.write.handler.CellWriteHandler;
import com.alibaba.excel.write.handler.context.CellWriteHandlerContext;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
 
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
public class ExcelFillCellMergePrevCol implements CellWriteHandler {
    private static final String KEY = "%s-%s";
    //所有的合并信息都存在了这个map里面
    Map<String, Integer> mergeInfo = new HashMap<>();

    public ExcelFillCellMergePrevCol() {
    }

    public ExcelFillCellMergePrevCol(Map<String, Integer> mergeInfo) {
        this.mergeInfo = mergeInfo;
    }

    @Override
    public void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head, Integer integer, Integer integer1, Boolean aBoolean) {

    }

    @Override
    public void afterCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Cell cell, Head head, Integer integer, Boolean aBoolean) {

    }

    @Override
    public void afterCellDataConverted(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, WriteCellData<?> cellData, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {
    }

    @Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, List<WriteCellData<?>> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {

        //当前行
        int curRowIndex = cell.getRowIndex();
        //当前列
        int curColIndex = cell.getColumnIndex();

        Integer num = mergeInfo.get(String.format(KEY, curRowIndex, curColIndex));
        if (null != num) {
            // 合并最后一行 ,列
            mergeWithPrevCol(writeSheetHolder, cell, curRowIndex, curColIndex, num);
        }
    }

    public void mergeWithPrevCol(WriteSheetHolder writeSheetHolder, Cell cell, int curRowIndex, int curColIndex, int num) {
        Sheet sheet = writeSheetHolder.getSheet();
        cell.setCellValue("合计");//需要合并的行写入的内容，我自己的是直接写死为‘合计’

        CellRangeAddress cellRangeAddress = new CellRangeAddress(curRowIndex, curRowIndex, curColIndex, curColIndex + num);
        sheet.addMergedRegion(cellRangeAddress);
    }

    //num从第几列开始增加多少列
    // curRowIndex 在第几行进行行合并
    // curColIndex 在第几列进行合并
    // num 合并多少格
    // 比如我上图中中心需要在第三行 从0列开始合并三列 所以我可以传入 (3,0,2)
    public void add(int curRowIndex, int curColIndex, int num) {
        mergeInfo.put(String.format(KEY, curRowIndex, curColIndex), num);
    }
}

easyExecl调用的合并的时候

ExcelFillCellMergePrevCol mergePrevCol = new ExcelFillCellMergePrevCol();
int headSize = 2;
//需要合并的为第几行、第几列至第几列
mergePrevCol.add(headSize, 0, 8);//第3行,第0列-第8列

EasyExcel.write(response.getOutputStream(),Object.class)
    
        .registerWriteHandler(mergePrevCol)//合并单元格