| | |
| | | examScoreExcel.setExamName("2021年10月**日保安员证培训考试"); |
| | | examScoreExcel.setName("张三"); |
| | | examScoreExcel.setIdCardNo("360XXX19XXXXXX****"); |
| | | examScoreExcel.setCandidateNo("2110**m0001"); |
| | | // examScoreExcel.setCandidateNo("2110**m0001"); |
| | | examScoreExcel.setLearnGrade(80); |
| | | list.add(examScoreExcel); |
| | | |
| | |
| | | examScoreExcel1.setExamName("2021年10月**日保安员证培训考试"); |
| | | examScoreExcel1.setName("李四"); |
| | | examScoreExcel1.setIdCardNo("360XXX19XXXXXX****"); |
| | | examScoreExcel1.setCandidateNo("2110**m0002"); |
| | | // examScoreExcel1.setCandidateNo("2110**m0002"); |
| | | examScoreExcel1.setLearnGrade(88); |
| | | list.add(examScoreExcel1); |
| | | // ExcelUtil.export(response, "实操成绩数据模板", "实操成绩数据表", list, ExamScoreExcel.class); |
| | |
| | | //按条件查询成绩数据 |
| | | List<ExportExamScoreExcel> examScoreExcels = examScoreService.exportExamScoreList(examScoreVO); |
| | | //导出成绩集合数据 |
| | | ExcelUtil.export(response, "成绩数据", "成绩数据表", examScoreExcels, ExportExamScoreExcel.class); |
| | | ExcelUtil.export(response, "成绩数据"+DateUtil.time(), "成绩数据表", examScoreExcels, ExportExamScoreExcel.class); |
| | | } |
| | | |
| | | /** |