easyExcel后台生成excel并上传到OSS，将文档地址返回给前端

整理下做笔记

1、Controller层

    @ApiOperation("导出")@RequestMapping(value = "/exportAnswerAll", method = RequestMethod.POST)@ResponseBodypublic Result exportAnswerAll(QuizUser quizUser) throws IOException {return Result.success(quizUserService.exportOSS(quizUser));}

2、Service层

2.1当只生成一个sheet时

    public String exportOSS(QuizUser quizUser) {List<QuizAnswerLevel> list = this.exportAnswer(quizUser);ByteArrayOutputStream out = new ByteArrayOutputStream();EasyExcel.write(out, QuizAnswerLevel.class).sheet("模板").doWrite(list);String url = resourceService.upload(new ByteArrayInputStream(out.toByteArray()), ExcelTypeEnum.XLSX.getValue(), "easyexcel");return url;}

 2.2、当生成多个sheet时