字符流导出

蚂蚁工兵

于 2020-11-03 11:48:46 发布

阅读量154

点赞数

本文链接：https://blog.csdn.net/chengxuhaha/article/details/109466530

版权

   dto格式 :@Excel(name = "资质名称", orderNum = "1")
   代码：
   List<GetPersonalAptitudeConfigPageListResponseDto> listY =
                personalAptitudeConfigMapperExt.getPersonalAptitudeConfigPageList(getPersonalAptitudeConfigPageListRequestDto);
        String dateNow = DateUtils.format(new Date(), DateUtils.DATE_PATTERN);
        HSSFWorkbook workbook = (HSSFWorkbook) ExcelExportUtil.exportExcel(new ExportParams("个人资质配置信息", dateNow, dateNow),
            GetPersonalAptitudeConfigPageListResponseDto.class, listY);

        try {
            OutputStream output = response.getOutputStream();
            response.reset();
            response.setHeader("Content-disposition", "attachment; filename=PersonalAptitudeConfig.xls");
            response.setContentType("application/msexcel");
            workbook.write(output);
            output.close();
        } catch (Exception e) {

            bhResponse = new BhResponse(ResponseMessageEnum.ERROR);
        }

        return bhResponse;