easypoi导出合并单元格并统计

官网: https://easypoi.mydoc.io/#text_228245

 <!-- easypoi导入导出excel -->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version> 4.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>4.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>4.2.0</version>
        </dependency>

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import org.apache.poi.ss.usermodel.Workbook;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.UnsupportedEncodingException;
import java.util.List;
public class AbstractExcelOut implements IExcelOut {
    private String fileName;
    private HttpServletResponse response;
    private AbstractExcelOut() {
    }
    public AbstractExcelOut(String fileName, HttpServletResponse response) {
        this.fileName = fileName;
        this.response = response;
        this.responseInit();
    }
    private void responseInit() {
        response.setContentType("application/vnd.ms-excel;charset=utf-8");
        response.setCharacterEncoding("utf-8");
        try {
            response.setHeader("Content-disposition", "attachment;filename=" + new String(fileName.getBytes("gb2312"), "ISO8859-1") + ".xls");
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        }
    }
//    @Override
//    public <T extends BaseRowModel> void excelOut(List<T> dataList, Class<T> tClass) throws IOException {
//        ServletOutputStream out = null;
//        out = response.getOutputStream();
//        ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLS, true);
//        Sheet sheet = new Sheet(1, 0, tClass);
//        //设置自适应宽度
//        sheet.setAutoWidth(Boolean.TRUE);
//        sheet.setSheetName(fileName);
//        writer.write(dataList, sheet);
//        writer.finish();
//        out.flush();
//        response.getOutputStream().close();
//        out.close();
//    }
    @Override
    public void excelOut(ExportParams exportParams, List<?> dataList, Class<?> tClass) throws Exception {
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, tClass, dataList);
        setExportExcelFormat(workbook);
    }
    /**
     * excel导出时
     * 返回头设置下载，并设置文件名
     * 注意：以下设置编码格式是为了ie，当前项目是ie下使用的。360或者谷歌可能会文件名会乱码。根据自己需要调整编码。或者不用设置这么多，直接outStream输出得了。
     *
     * @param workbook
     * @throws Exception
     */
    private void setExportExcelFormat(Workbook workbook) throws Exception {
        ServletOutputStream outStream = null;
        try {
            outStream = response.getOutputStream();
            workbook.write(outStream);
        } finally {
            outStream.close();
        }
    }
}

import cn.afterturn.easypoi.excel.entity.ExportParams;
import java.util.List;
public interface IExcelOut {
//    void responseInit() throws UnsupportedEncodingException;
//    <T extends BaseRowModel> void excelOut(List<T> dataList, Class<T> tClass) throws IOException;
     void excelOut(ExportParams exportParams, List<?> dataList, Class<?> tClass) throws Exception;
}

    String ORDER_File_NAME = "order-excel";
    String ORDER_SHEET_NAME = "order-excel";
    String ORDER_TITLE = "采购统计表";
AbstractExcelOut abstractExcelOut = new AbstractExcelOut(ORDER_File_NAME, response);
        abstractExcelOut.excelOut(new ExportParams(ORDER_TITLE, ORDER_SHEET_NAME), resultList, YmzcOrderStatisticalVo.class);

关于合并只有两点：
1、类的数据结构。
2、注解
    @ExcelCollection(name = "") 集合使用
    @Excel(name = "采购数量合计（支）", width = 30, orderNum = "5",needMerge = true, isStatistics = true)
        name:列的标题名称，width ：表格的宽度， orderNum ：排序（注意每个类中的排序为单独的  不同类排序不通用） 
        needMerge ： 是否合并单元格， isStatistics：是否进行统计（若为true，则在表格最后自动生成最终统计）
@Data
@ApiModel("采购统计以及导出")
public class YmzcOrderStatisticalVo implements Serializable {
    @ExcelCollection(name = "")
    @ApiModelProperty(value = "")
    private List<ExcelSheetHead> number;
    /**
     * 采购单位名称
     */
    @ApiModelProperty(value = "采购单位名称")
    @Excel(name = "采购单位", width = 30, orderNum = "3",needMerge = true)
    private String creator;
    /**
     * 采购详情内容
     */
    @ApiModelProperty(value = "采购疫苗详情")
    @ExcelCollection(name = "", orderNum = "4")
    private List<YmzcOrderVaccineDetailsVo> detailsList;
    /**
     * 采购单位ID
     */
    @ApiModelProperty(value = "采购单位ID")
    private Long creatorId;
    /**
     * 采购数量合计（支）
     */
    @ApiModelProperty(value = "采购数量合计（支）")
    @Excel(name = "采购数量合计（支）", width = 30, orderNum = "5",needMerge = true, isStatistics = true)
    private Integer statisticalNumber;
    /**
     * 采购金额合计
     */
    @ApiModelProperty(value = "采购数量合计（支）")
    @Excel(name = "采购金额合计(元)", width = 30, orderNum = "6",needMerge = true, isStatistics = true)
    private BigDecimal statisticalPrice;
}