package com.izouma.nineth.utils.excel; import com.alibaba.excel.EasyExcel; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.util.List; public class ExcelUtils { public static void export(HttpServletResponse response, List 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 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 MetaPointTypeEnumConverter()) .registerConverter(new MetaIsLandTypeEnumConverter()) .doWrite(data); } }