cn.hutool.poi导出,导出

import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;@Retention(RetentionPolicy.RUNTIME)
public @interface Exceli {String name() default ""; // 表头名称int orderNum() default 0; // 排序序号
}

 public static void downloadExcelByExceli(List<?> data, Class s, HttpServletResponse response) {ExcelWriter writer = ExcelUtil.getWriter(true);writer.setSheet("sheet1");Sheet sheet = writer.getSheet();// 获取所有带@Excel注解的字段并按顺序排序List<Field> fields = Arrays.stream(s.getDeclaredFields()).filter(f -> f.isAnnotationPresent(Exceli.class)).sorted(Comparator.comparingInt(f -> f.getAnnotation(Exceli.class).orderNum())).collect(Collectors.toList());// 创建表头行Row headerRow = sheet.createRow(0);for (int i = 0; i < fields.size(); i++) {Field field = fields.get(i);Exceli excel = field.getAnnotation(Exceli.class);Cell cell = headerRow.createCell(i);// 设置表头文本
            cell.setCellValue(excel.name());}List<Map<String, Object>> collect = data.stream().map(item -> {Map<String, Object> map = new LinkedHashMap<>();for (Field field : fields) {try {field.setAccessible(true);Object value = field.get(item);Exceli excel = field.getAnnotation(Exceli.class);map.put(excel.name(), value);} catch (IllegalAccessException e) {throw new RuntimeException("字段值获取失败：" + field.getName(), e);}}return map;}).collect(Collectors.toList());writer.write(collect, true);// 输出响应response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");response.setHeader("Content-Disposition", "attachment;filename=data.xlsx");ServletOutputStream out = null;try {out = response.getOutputStream();} catch (IOException e) {log.error("下载文件失败", e);response.setContentType(MediaType.APPLICATION_JSON_VALUE);response.setStatus(500);throw new ResponseException(-1, "下载出错");} finally {if (out != null) {writer.flush(out, true);IoUtil.close(out);}}}