ExcelWriter 导出

public void exportOrderList(HttpServletResponse response, @RequestBody ExpressOrderQueryDto expressOrderQueryDto) throws IOException{
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        String fileName = URLEncoder.encode(DateUtil.getCurrentDate(DateUtil.DATE_TIME_FORMAT_YYYYMMDDHHMISS), "utf-8");
        response.setHeader("Content-disposition", "attachment;filename=Order" + fileName);

        expressOrderService.exportOrderList(response.getOutputStream(),expressOrderQueryDto);
    }
 @Override
    public void exportOrderList(OutputStream outputStream, ExpressOrderQueryDto expressOrderQueryDto) {
        List<ExpressOrderVo> list = expressOrderMapper.list(expressOrderQueryDto, getCurrentAccount().getCompanyId());
        ExcelWriter excelWriter = EasyExcel.write(outputStream).build();
        WriteSheet writeSheetOrder = EasyExcelFactory.writerSheet().head(ExpressOrderExcelVo.class).build();
        try {
            excelWriter.write(list ,writeSheetOrder);
        } catch (Exception e) {
            log.error("导出订单失败, 异常:", e);
        } finally {
            if(excelWriter != null){
                excelWriter.finish();
            }
        }
    }

 

posted @ 2025-03-12 13:45  客至在水一方  阅读(50)  评论(0)    收藏  举报