使用easyExcel导出excel时相同数据合并

最新推荐文章于 2024-08-19 10:30:57 发布

浩克的星冰乐

最新推荐文章于 2024-08-19 10:30:57 发布

阅读量2.7k

点赞数

分类专栏： excel poi 文章标签： excel

本文链接：https://blog.csdn.net/weixin_44090537/article/details/107836590

版权

合并规则类

package cn.itcast.boot.ExcelUtil;

import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.write.handler.CellWriteHandler;
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.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import java.util.List;

/**
 * excel导出数据内容单元格合并规则
 */
public class ExcelFileCellMergeStrategy implements CellWriteHandler {
   
    /**
     * 合并列的范围索引
     */
    private int[] mergeColumnIndex;
    /**
     * 合并起始行索引
     */
    private int mergeRowIndex;

    public ExcelFileCellMergeStrategy(int[] mergeColumnIndex, int mergeRowIndex) {
   
        this.mergeColumnIndex = mergeColumnIndex;
        this.merg