html
<form class="form-horizontal m-t" id="signupForm" enctype="multipart/form-data">
<div class="form-group">
<label class="col-sm-3 control-label">选择文件:</label>
<div class="col-sm-8">
<input id="file" name="file" class="form-control" type="file">
</div>
</div>
js
function save() {
var fd = new FormData($("#signupForm")[0]);
$.ajax({
url: "/upa/shopDrug/importExcel",
type: "POST",
data: fd,
processData: false,
contentType: false,
success : function(data) {
if (data.code == 0) {
parent.layer.msg("操作成功");
parent.reLoad();
var index = parent.layer.getFrameIndex(window.name); // 获取窗口索引
parent.layer.close(index);
} else {
parent.layer.alert(data.msg)
}
},
error : function(data) {
parent.layer.alert("Connection error");
}
});
controller
@ResponseBody
@PostMapping("/importExcel")
public R importExcel(@RequestParam("file") MultipartFile file,HttpServletRequest request){
//文件类型
String fileType = file.getContentType();
//名字
// if (!".xls".equals(fileType)) {
// return R.error("文件类型不对,请上传excel.xls文件");
// }
String fileName = file.getOriginalFilename();
try {
InputStream ins = file.getInputStream();
FileInputStream inputStream = (FileInputStream )ins ;
HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
shopDrugService.importExcel(workbook,getUser());
ins.close();
} catch (IOException e) {
log.error(e.toString());
return R.error(e.getMessage());
}
return R.ok();
}