@GetMapping("excel/download")@ApiOperation(value = "模板下載")public void getUserRecordTemplate(HttpServletResponse response, HttpServletRequest request) throws IOException {OutputStream outputStream = response.getOutputStream();InputStream inputStream = new ClassPathResource("example/excel/download_template_user_record.xlsx").getInputStream();try {String fileName = "導入模板";String fileName3 = URLEncoder.encode(fileName, "utf-8");response.setHeader("Content-disposition", "attachment;filename*=utf-8''"+fileName3+".xlsx");response.setContentType("application/msexcel");// 定義輸出類型response.setCharacterEncoding("UTF-8");//獲取該類聲明的所有字段Field[] fields = UserRecordExcelExportResult.class.getDeclaredFields();//響應字段對應的下拉集合Map<Integer, String[]> map = new HashMap<>();Field field = null;
//從數據庫里獲取下拉框選項List<XcUserLevel> list = xcUserLevelService.list();
//			List<SysDept> list1 = sysDeptService.list();List<String> collect = list.stream().map(XcUserLevel::getName).collect(Collectors.toList());
//			List<String> collect1 = list1.stream().map(SysDept::getName).collect(Collectors.toList());
//找到需要對應的下拉框位置
//			map.put(11,collect1.toArray(new String[0]));map.put(12,collect.toArray(new String[0]));// 循環判斷哪些字段有下拉數據集，并獲取/*for (int i = 0; i < fields.length; i++) {field = fields[i];// 解析注解信息DropDownSetField dropDownSetField = field.getAnnotation(DropDownSetField.class);if (null != dropDownSetField) {//調用下拉框數據源的方法String[] source = ResoveDropAnnotationUtil.dynamicListResove2(dropDownSetField, field.getName(),staffId);if (null != source && source.length > 0) {map.put(i, source);}}}*/ExcelWriter excelWriter = EasyExcel.write(outputStream)
//將保存下拉框的map放入excelWriter.registerWriteHandler(new CustomSheetWriteHandler(map)).withTemplate(inputStream).build();WriteSheet writeSheet = EasyExcel.writerSheet(0,"Sheet1").build();excelWriter.write(new ArrayList<>(), writeSheet);excelWriter.finish();outputStream.close();} catch (Exception e) {e.printStackTrace();}}

從resoues包里獲取excel文件