## 一、概述 提供一個樣板，用于標準化的處理文件導入數據的場景； ## 二、示范 前端把excel文件處理為base64，作為字符串post傳入后端； controller: ``` @PostMapping("/api/business/card/cardinfo/import/candidate") public ResponseEntity<ResponseObject> changeLogo(@RequestHeader String rayAccessToken, @RequestParam String excelBase64) { return ResponseEntity.ok(cardInfoService.importCandidate(excelBase64)); } ``` service: ``` @RayServiceMethod @Transactional public ResponseObject importCandidate(String excelBase64) { Workbook wb = Base64Util.getWorkbookByBase64(Base64Util.trimHeadFromFront(excelBase64)); Sheet sheet = wb.getSheetAt(0); for (int i = 0; i < sheet.getPhysicalNumberOfRows(); i++) { Row row = sheet.getRow(i); CardInfoCandidate candidate = new CardInfoCandidate(); candidate.setAccessCode(ExcelUtil.getCellValue(row.getCell(0)).toString()); cardInfoCandidateDao.save(candidate); } return responseObj; } ``` >[danger] 導入非常簡單，就是傳入base64，后臺解析成excel文件，即可；