使用easyexcel上传并读取excel内容

public ResponseData readExcel(MultipartFile file) throws Exception { if (null == file) { throw new ServiceException(FILE_NOT_FOUND); } Sheet sheet = new Sheet(1, 1, ClanExcelVo.class); InputStream fileInputStream = new FileInputStream(multipartFileToFile(file)); List<Object> read1 = EasyExcelFactory.read(fileInputStream, sheet); // 存 ExcelMode 实体的 集合 List<ClanExcelVo> list = new ArrayList<ClanExcelVo>(); for (Object o : read1) { list.add((ClanExcelVo) o); } return ResponseData.success(list); }

下面是将MultipartFile转file

public static File multipartFileToFile(MultipartFile file) throws Exception { File toFile = null; if (file.equals("") || file.getSize() <= 0) { file = null; } else { InputStream ins = null; ins = file.getInputStream(); toFile = new File(file.getOriginalFilename()); inputStreamToFile(ins, toFile); ins.close(); } return toFile; } public static void inputStreamToFile(InputStream ins, File file) { try { OutputStream os = new FileOutputStream(file); int bytesRead = 0; byte[] buffer = new byte[8192]; while ((bytesRead = ins.read(buffer, 0, 8192)) != -1) { os.write(buffer, 0, bytesRead); } os.close(); ins.close(); } catch (Exception e) { e.printStackTrace(); } }