导入Excel核心代码
@ApiOperation("导入Excel")
@PostMapping("/importExcel")
public ActionResult importExcel(@RequestParam("file") MultipartFile file){
if (file.getOriginalFilename().contains(".xlsx")) {
ImportParams params = new ImportParams();
params.setTitleRows(1);
params.setHeadRows(1);
List<ControlsEntity> list = null;
try {
list = ExcelImportUtil.importExcel(file.getInputStream(), ControlsEntity.class, params);
} catch (Exception e) {
e.printStackTrace();
}
//list.forEach(System.out::println);
ActionResult actionResult = controlsService.importAddSave(list);
return actionResult;
} else {
return ActionResult.fail("选择文件不符合导入");
}
// ActionResult actionResult = importExcelLocal();
// return actionResult;
}
本地指定路径上传
/**
* 本地测试
* @return
*/
public ActionResult importExcelLocal(){
String file = "D:\\workspace\\zsh_code\\i3_plat_portal\\temp\\1649669032468_import.xlsx";
FileInputStream inputtSream = null;
try {
inputtSream = new FileInputStream(file);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
ImportParams params = new ImportParams();
params.setTitleRows(1);
params.setHeadRows(1);
List<ControlsEntity> list = null;
try {
list = ExcelImportUtil.importExcel(inputtSream, ControlsEntity.class, params);
} catch (Exception e) {
e.printStackTrace();
}
//list.forEach(System.out::println);
ActionResult actionResult = controlsService.importAddSave(list);
return actionResult;
}
1,点击Body,
2,选择 form-data,
3,在KEY那栏,选择 File 类型
Key 对应接口参数名字 file
public ActionResult importExcel(@RequestParam("file") MultipartFile file){
4,Value处,浏览目录上传文件即可,如下图:会显示传递的参数名称 xxx.xlsx
这样就设置完成了,最后点击请求测试。
新增到数据库失败
新增到数据库成功