1:接收文件
@Override
@RequestMapping(value = "/syncUserInfo", method = RequestMethod.POST)
@ResponseBody
public Response syncUserInfo(@RequestParam("file") MultipartFile file) {
// 分析文件
StopWatch clock = new StopWatch();
clock.start();
userService.syncUserInfo(file);
clock.stop();
long handlingTime = clock.getTime();
logger.info("上传成功, 上传文件耗时: " + handlingTime + "ms");
return Response.buildSuccess();
}
2:解析excel数据
@Override
public void syncUserInfo(MultipartFile file) {
String fileExtension = Files.getFileExtension(file.getOriginalFilename());
if (!"XLSX".equalsIgnoreCase(fileExtension)) {
throw new Exception();
}
try {
XSSFWorkb