spring boot集成excel导入导出

/**

• 文件的导入

• @param reqMap

• @return

*/

@SuppressWarnings({ “unused”, “rawtypes” })

@RequestMapping(value="/excelController/importWaterFee",method = RequestMethod.POST)

public String importWaterFee(Model model,@RequestParam(value=“file”) MultipartFile file){

//文件上传后处理文件

R r = feebuildService.importFeeBuildExcel(file);

return “redirect:/admin/feebuild”;

}

/**

• 导入excel 的数据到库里面去

*/

@SuppressWarnings(“rawtypes”)

@Override

public R importFeeBuildExcel(MultipartFile file) {

String fileName = file.getOriginalFilename();

String fileType = fileName.substring(fileName.lastIndexOf(".") + 1);

String realFileName = UUID.randomUUID().toString() + “.” + fileType;

String relativePath = env.getProperty(“image.file.excel.dir”);

// 当前app根目录

String rootPath = Thread.currentThread().getContextClassLoader().getResource("").getPath();

// 文件夹是否存在，不存在就创建

File fileDir = new File(rootPath + File.separator + relativePath);

if (!fileDir.exists())

fileDir.setWritable(true);

fileDir.mkdirs();

File tempFile = new File(fileDir, realFileName);

try {

file.transferTo(tempFile);

//处理Excel构建数据

List FeebuildList = readExcelContent(tempFile);

int count = mapper.insertBatch(FeebuildList);

return R.success();

} catch (IOException e) {

LOGGER.error(e.getMessage(),e.toString());

return R.error(“导入失败”);

}

}

public List readExcelContent(File file) {

List list = Lists.newArrayList();

String s