EasyExcel合并单元格（同列相同数据合并）

绝地灬酷狼 2023-09-25 17:56 81阅读 0赞

![在这里插入图片描述][0c6567833fb94e91b802edcc3429c46f.png]

合并后效果如下：  
![在这里插入图片描述][3650c87a0ed144efacea3b57663ed5b1.png]  
合并策略代码：

public class CustomMergeStrategy extends AbstractMergeStrategy {
        
    
    	/**
    	 * 分组，每几行合并一次
    	 */
    	private List<List<Integer>> mergeColDataGroupCountList;
    
    	/**
    	 * 目标合并列index
    	 */
    	private List<Integer> targetColumnIndex;
    	/**
    	 * 	需要开始合并单元格的首行index
     	 */
    	private Integer rowIndex;
    
    	/**
    	 * 	mergeColDataList为待合并目标列的值
     	 */
    	public CustomMergeStrategy(List<List<String>> mergeColDataList, List<Integer> targetColumnIndex) {
        
    		this.mergeColDataGroupCountList = getGroupCountList(mergeColDataList);
    		this.targetColumnIndex = targetColumnIndex;
    	}
    
    
    	@Override
    	protected void merge(Sheet sheet, Cell cell, Head head, Integer relativeRowIndex) {
        
    
    		if (null == rowIndex) {
        
    			rowIndex = cell.getRowIndex();
    		}
    		// 仅从首行以及目标列的单元格开始合并，忽略其他
    		if (cell.getRowIndex() == rowIndex && targetColumnIndex.contains(cell.getColumnIndex())) {
        
    			//找到对应的需要合并的列
    			AtomicInteger i = new AtomicInteger(0);
    			Optional<Integer> first = targetColumnIndex.stream().filter(col -> {
        
    				i.getAndIncrement();
    				return col == cell.getColumnIndex();
    			}).findFirst();
    			mergeGroupColumn(sheet, first.get());
    		}
    	}
    
    	private void mergeGroupColumn(Sheet sheet, Integer index) {
        
    		int rowCount = rowIndex;
    		for (Integer count : mergeColDataGroupCountList.get(index)) {
        
    			if (count == 1) {
        
    				rowCount += count;
    				continue;
    			}
    			// 合并单元格
    			CellRangeAddress cellRangeAddress = new CellRangeAddress(rowCount, rowCount + count - 1,
    					targetColumnIndex.get(index), targetColumnIndex.get(index));
    			sheet.addMergedRegionUnsafe(cellRangeAddress);
    			rowCount += count;
    		}
    	}
    
    	/**
    	 * 	该方法将目标列根据值是否相同连续可合并，存储可合并的行数
     	 */
    	private List<List<Integer>> getGroupCountList(List<List<String>> exportDataList) {
        
    		if (CollUtil.isEmpty(exportDataList)) {
        
    			return new ArrayList<>();
    		}
    		List<List<Integer>> groupCountListList = new ArrayList<>();
    		exportDataList.forEach(dataList->{
        
    			List<Integer> groupCountList = new ArrayList<>();
    			int count = 1;
    			for (int i = 1; i < dataList.size(); i++) {
        
    				if (dataList.get(i).equals(dataList.get(i - 1))) {
        
    					count++;
    				} else {
        
    					groupCountList.add(count);
    					count = 1;
    				}
    			}
    			// 处理完最后一条后
    			groupCountList.add(count);
    			groupCountListList.add(groupCountList);
    		});
    		return groupCountListList;
    	}
    }

使用：

//序号列和运营公司列需要合并单元格
    		List<List<String>> mergeColDataList = Stream.of(data.stream().map(BridgeTypeLengthExcel::getNum).collect(Collectors.toList()),
    				data.stream().map(BridgeTypeLengthExcel::getOperateDeptName).collect(Collectors.toList())).collect(Collectors.toList());
    		//第一列(index=0)和第二列(index=1)
    		List<Integer> mergeColIndexList = Stream.of(0, 1).collect(Collectors.toList());
    		//内部finish的时候会自动关闭流
    		EasyExcel.write(response.getOutputStream(), BridgeTypeLengthExcel.class)
    				.registerWriteHandler(
    						new CustomMergeStrategy(
    								mergeColDataList, mergeColIndexList
    						)
    				)
    				.sheet("统计")
    				.doWrite(data);

主体代码来自网络，按自己业务修改，支持多列相同数据合并。

[0c6567833fb94e91b802edcc3429c46f.png]: https://img-blog.csdnimg.cn/0c6567833fb94e91b802edcc3429c46f.png
[3650c87a0ed144efacea3b57663ed5b1.png]: https://img-blog.csdnimg.cn/3650c87a0ed144efacea3b57663ed5b1.png