/** * @Author: Kerwin * * @Description: 入组风险统计 导出 **/ @RequestMapping(value = "/exportRiskList",method = RequestMethod.POST) public Result exportRiskList( @RequestBody DrgRiskModel drgRiskModel,HttpServletRequest request, HttpServletResponse response) throws Exception { Result riskList = new Result<>(); try { PnUser pnuser = this.getPnuser(request); String per= this.buildDataPermissionSql(pnuser); drgRiskModel = drgRiskModel.getNewDrg(drgRiskModel); // 获取需要导出的数组 List<DrgRiskExport> riskStatModels = drgService.exportRiskList(drgRiskModel,per); // 表头数组 内部数组代表行数 外部代表列数 List<List<String>> list =new ArrayList<>(); List<String>headList =new ArrayList<>(); List<String> stringList =Arrays.asList(header); list.add(stringList); list.add(headList); ServletOutputStream outputStream = response.getOutputStream(); ExcelWriter excelWriter = EasyExcelFactory.write(outputStream).head(list).build(); WriteSheet writesheet =EasyExcelFactory.writerSheet().head(list).build(); excelWriter.write(riskStatModels ,writesheet); excelWriter.finish(); outputStream.close(); }catch (Exception e) { log.info("入组分析结果错误:" + e.getMessage()); riskList.error(e.getMessage()); } return null; }
EasyExcel 动态表头生成
最新推荐文章于 2024-04-09 11:07:43 发布