poi导出excel 并实现合并单元格

原图

合并之后图片

工具类ExportExcel
package com.daxiao.test.util;

/**

• Created by Bob on 2021/5/12.
  */
  import java.io.FileOutputStream;
  import java.io.IOException;
  import java.text.DecimalFormat;
  import java.util.HashMap;
  import java.util.List;
  import java.util.Map;
  import java.util.regex.Pattern;

import com.daxiao.test.poJo.MergeModel;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExportExcel {
/**
* 创建excel文件
* @param objData 数据
* @param fileName 文件名
* @param sheetName sheet名
* @param columns 表头
* @param mergeIndex 需要合并的列号集合
* @return
*/
public static int exportToExcelForXlsx(List<List> objData,String fileName, String sheetName, List columns,List mergeIndex) {
int flag = 0;

    // 创建工作薄
    XSSFWorkbook wb = new XSSFWorkbook();
    // sheet1
    XSSFSheet sheet1 = wb.createSheet(sheetName);

    //设置样式
    XSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HorizontalAlignment.CENTER);//水平对齐

    //表头
    sheet1.createFreezePane(0, 1);//冻结表头
    XSSFRow sheet1row1 = sheet1.createRow((short) 0);
    sheet1row