raex_back/src/main/java/com/izouma/nineth/utils/excel/ExcelUtils.java

package com.izouma.nineth.utils.excel;

import com.alibaba.excel.EasyExcel;
import com.izouma.nineth.utils.MetaTaskTargetConverter;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

public class ExcelUtils<T> {
    public static <T> void export(HttpServletResponse response, List<T> data) throws IOException {
        String fileName = "data.xlsx";
        if (data != null && !data.isEmpty()) {
            fileName = data.get(0).getClass().getSimpleName() + ".xlsx";
        }
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
        EasyExcel.write(response.getOutputStream(), data.get(0).getClass()).sheet("sheet")
                .registerConverter(new LocalDateConverter())
                .registerConverter(new LocalDateTimeConverter())
                .registerConverter(new BigIntegerConverter())
                .registerConverter(new AuthStatusConverter())
                .registerConverter(new OrderStatusConverter())
                .registerConverter(new PayMethodConverter())
                .registerConverter(new MetaTaskTypeConverter())
                .registerConverter(new MetaTaskTypeConverter())
                .registerConverter(new MetaTaskStatusConverter())
                .registerConverter(new CoordinateDTOConverter())
                .registerConverter(new EntryModelTypeConverter())
                .registerConverter(new GameCopyTypeConverter())
                .registerConverter(new MetaGameAwardExcelConverter())
                .registerConverter(new MetaGameConverter())
                .registerConverter(new MetaItemEnumConverter())
                .registerConverter(new MetaRegionEnumConverter())
                .registerConverter(new MetaZombieTypeConverter())
                .registerConverter(new MetaZombieDTOConverter())
                .registerConverter(new MintActivityRuleConverter())
                .registerConverter(new ListConverter())
                .registerConverter(new OperationSourceConverter())
                .registerConverter(new RecordTypeConverter())
                .registerConverter(new MetaIsLandTypeEnumConverter())
                .registerConverter(new MoveTypeConverter())
                .registerConverter(new MetaAwardTypeEnumConverter())
                .registerConverter(new MetaPurchaseMethodEnumConverter())
                .registerConverter(new MetaTaskTargetConverter())
                .registerConverter(new MetaStoreCommodityTypeConverter())
                .registerConverter(new MetaResourcesTypeConverter())
                .registerConverter(new ChatTypeConverter())
                .registerConverter(new MetaSwitchTypeConverter())
                .registerConverter(new MetaPropTypeConverter())
                .registerConverter(new MetaLuckyDrawAwardModelConverter())
                .registerConverter(new MetaPropTriggerTypeConverter())
                .registerConverter(new MetaPropUsedTypeConverter())
                .registerConverter(new WithdrawStatusConverter())
                .doWrite(data);
    }
}