excel导出实现

叁歲伎倆 2024-03-22 09:36 87阅读 0赞

@Override
        public void excelExport(Long mainId, HttpServletResponse response) {
            if (ObjectUtil.isEmpty(mainId)) {
                //抛异常
                throw  new SafetyBussinessException(SafetyErrorCodeEnum.FILE_EXPORT_EROR);
            }
            //主表id
            //查询表中所有SafetyGreatDangerInfo的信息
            DangerInfoListDTO dangerInfoListDTO = new DangerInfoListDTO();
            dangerInfoListDTO.setId(mainId);
            dangerInfoListDTO.setSize(10000);
            Page<DangerInfoListVO> page = this.dangerInfoMapper.getPage(dangerInfoListDTO);
            List<DangerInfoListVO> records = page.getRecords();
    
            if (CollUtil.isEmpty(records)) {
                throw  new SafetyBussinessException(SafetyErrorCodeEnum.FILE_EXPORT_EROR);
            }
    
            String fileName = "dangerList" + DateUtil.today() + ".xlsx";
            response.setContentType("application/octet-stream;charset=UTF-8");
    //这里不一定有用
            try {
                response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
            } catch (UnsupportedEncodingException e) {
                throw  new SafetyBussinessException(SafetyErrorCodeEnum.FILE_EXPORT_EROR);
            }
    
    
            List<safetyGreatDangerExcelBean> collect = records.stream()
                    .map(info -> BeanUtil.toBean(info, safetyGreatDangerExcelBean.class))
    //                        CopyOptions.create().setFieldMapping(MapUtil.of(Pair.of("condition", "conditionName")))))
    //
                    .collect(Collectors.toList());
            System.out.println(JSONUtil.toJsonStr(collect));
            ExcelUtil.export(response, fileName, safetyGreatDangerExcelBean.class, collect);
        }

void excelExport(Long surveyId, HttpServletResponse response);

@ApiOperation(value = "工程测设点位EXCEL导出", notes = "工程测设点位EXCEL导出")
        @PostMapping("/export/{surveyId}")
        public R excelExport(@PathVariable("surveyId") Long surveyId, HttpServletResponse response) {
            this.safetyEducationService.excelExport(surveyId, response);
            return R.ok();
        }

还需一个excelBean

@Data
    @EqualsAndHashCode
    @ColumnWidth(15)
    public class safetyGreatDangerExcelBean {
    
        @ExcelProperty("工程分类")
        @ColumnWidth(20)
        private String greatDangerName;
    
        @ExcelProperty("危大工程条件判断")
        private String condition;
    
        @ExcelProperty("规模")
        private String scale;
    
        @ExcelProperty("方案名称")
        private String schemeName;
    
        @ExcelProperty("计划论证时间")
        private LocalDateTime planArgumentTime;
    
        @ExcelProperty("方案负责人")
        @ColumnWidth(50)
        private String programPrincipal;
    
    }

注意post要头文件形式正确，并且点击save Response 保存文件![26bb34e548ca4b9ba4eea1bbd720ac17.png][]

localdateTime转换excel报错，直接在excelbean类用string接收

@Data
    @EqualsAndHashCode
    @ColumnWidth(15)
    public class safetyGreatDangerExcelBean {
    
        @ExcelProperty("工程分类")
        @ColumnWidth(20)
        private String greatDangerName;
    
        @ExcelProperty("危大工程条件判断")
        private String condition;
    
    
    
        @ExcelProperty("规模")
        private String scale;
    
        @ExcelProperty("方案名称")
        private String schemeName;
    
    //改成string接收
    
        @ExcelProperty("计划论证时间")
        private String planArgumentTime;
    
        @ExcelProperty("方案负责人")
        @ColumnWidth(50)
        private String programPrincipal;
    
    }

还有一个，Excel有一个工具类的 设定在公共包：

import com.alibaba.excel.EasyExcel;
    import com.yunjian.build.business.common.api.exception.CommonBussinessException;
    import com.yunjian.build.business.common.api.exception.CommonErrorCodeEnum;
    import lombok.extern.slf4j.Slf4j;
    
    import javax.servlet.http.HttpServletResponse;
    import java.io.IOException;
    import java.util.List;
    
    /**
     * COPYRIGHT©大连云建数科科技有限公司
     *
     * @description:
     * @author: tyronekim
     * @date: 2023/4/24
     **/
    @Slf4j
    public class ExcelUtil {
    
        public static <T> void export(HttpServletResponse response, String fileName, Class<T> clz, List<T> dataList) {
            try {
                response.setContentType("application/vnd.ms-excel");
                response.setCharacterEncoding("utf-8");
                // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
                response.setHeader("Content-disposition", "attachment;filename=" + fileName);
                EasyExcel.write(response.getOutputStream(), clz).sheet().doWrite(dataList);
            } catch (IOException e) {
                log.error("EXCEL导出IO流异常:【{}】", fileName, e);
                throw new CommonBussinessException(CommonErrorCodeEnum.EXCEL_WRITER_ERROR);
            }
        }
    
    }

[26bb34e548ca4b9ba4eea1bbd720ac17.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/caeed4a4167d4404b963e2a85f0f74e4.png