EasyExcel 单元格合并

1. 继承AbstractMergeStrategy，重写merge方法

    参数介绍:

     countryCount 合并行数集合。 如下图 list则为6,5。同理productTypeCount

     

import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.write.merge.AbstractMergeStrategy;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import java.util.List;

public class MyMergeStrategy extends AbstractMergeStrategy {

    private Sheet sheet;
    private List<Integer> countryCount;
    private List<Integer> productTypeCount;
    public MyMergeStrategy(List<Integer> countryCount,List<Integer> productTypeCount) {
        this.countryCount = countryCount;
        this.productTypeCount = productTypeCount;
    }

    // 按照分组将各种类别分别合并成一个单元格
    private void mergeCountryColumn(Integer index) {
        Integer rowCnt = 1;
        for (Integer count : countryCount) {
            if (count == 1) {
                rowCnt += count;
                continue;
            }
            CellRangeAddress cellRangeAddress = new CellRangeAddress(rowCnt, rowCnt + count - 1, index, index);
            sheet.addMergedRegionUnsafe(cellRangeAddress);
            rowCnt += count;
        }
    }
    // 按照分组将各种类别分别合并成一个单元格
    private void mergeProductTypeColumn(Integer index) {
        Integer rowCnt = 1;
        for (Integer count : productTypeCount) {
            if (count == 1) {
                rowCnt += count;
                continue;
            }
            CellRangeAddress cellRangeAddress = new CellRangeAddress(rowCnt, rowCnt + count - 1, index, index);
            sheet.addMergedRegionUnsafe(cellRangeAddress);
            rowCnt += count;
        }
    }


    @Override
    protected void merge(Sheet sheet, Cell cell, Head head, Integer integer) {
        this.sheet = sheet;
        if (cell.getRowIndex() == 1) {
            switch (cell.getColumnIndex()) {
                case 0:
                    this.mergeCountryColumn(0);
                    break;
                case 1:
                    this.mergeProductTypeColumn(1);
                    break;
                default:
                    break;
            }
        }
    }
}

2. Excel导出

EasyExcel.write(response.getOutputStream(), clazz).registerWriteHandler(abstractMergeStrategy).excelType(ExcelTypeEnum.XLSX).sheet(sheetName);