Easy-poi快速导出百万数据只需25秒

Easy-poi快速导出百万数据只需25秒

1 整合easy-poi

  pom文件 

  <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.0.1</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.0.1</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.0.1</version>
        </dependency>

springboot整合的pom
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-spring-boot-starter</artifactId>
    <version>3.3.0</version>
</dependency>

2 表格样式调整

public class ExcelStyleUtils implements IExcelExportStyler {

private static final short STRING_FORMAT = (short) BuiltinFormats.getBuiltinFormat("TEXT");
private static final short FONT_SIZE_TEN = 10;
private static final short FONT_SIZE_ELEVEN = 11;
private static final short FONT_SIZE_TWELVE = 12;

/**
 * 大标题样式
 */
private CellStyle headerStyle;
/**
 * 每列标题样式
 */
private CellStyle titleStyle;
/**
 * 数据行样式
 */
private CellStyle styles;

public ExcelStyleUtils(Workbook workbook) {
    this.init(workbook);
}

/**
 * 初始化样式
 *
 * @param workbook
 */
private void init(Workbook workbook) {
    this.headerStyle = initHeaderStyle(workbook);
    this.titleStyle = initTitleStyle(workbook);
    this.styles = initStyles(workbook);
}


/**
 * 大标题样式
 *
 * @param color
 * @return
 */
@Override
public CellStyle getHeaderStyle(short color) {
    return headerStyle;
}

/**
 * 每列标题样式
 *
 * @param color
 * @return
 */
@Override
public CellStyle getTitleStyle(short color) {
    return titleStyle;
}

/**
 * 数据行样式
 *
 * @param parity 可以用来表示奇偶行
 * @param entity 数据内容
 * @return 样式
 */
@Override
public CellStyle getStyles(boolean parity, ExcelExportEntity entity) {
    return styles;
}

/**
 * 获取样式方法
 *
 * @param dataRow 数据行
 * @param obj     对象
 * @param data    数据
 */
public CellStyle getStyles(Cell cell, int dataRow, ExcelExportEntity entity, Object obj, Object data) {
    return getStyles(true, entity);
}

/**
 * 模板使用的样式设置
 */
@Override
public CellStyle getTemplateStyles(boolean isSingle, ExcelForEachParams excelForEachParams) {
    return null;
}

/**
 * 初始化--大标题样式
 *
 * @param workbook
 * @return
 */
private Cel