前端导入使用vue和bootstrap
<a v-if="hasPermission('ship:squadroncheckresult:importExcel')" class="btn btn-primary fl ml5" data-toggle="modal" data-target="#importModa1"><i class="fa fa-upload"></i> 导入</a>//按钮
<!-- 模态框(Modal)导入 -->
<div class="modal fade" id="importModa1" tabindex="-1" role="dialog" aria-labelledby="importModalLabel" aria-hidden="true" data-backdrop="static">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"
aria-hidden="true">×
</button>
<h4 class="modal-title" id="importModalLabel">
提示:
</h4>
</div>
<div class="modal-body">
<form class="form-horizontal" id="importForm" role="form" enctype="multipart/form-data">
<div class="form-group">
<label class="col-sm-4 control-label">选择文件:</label>
<div class="col-sm-8">
<input type="file" name="uploadFile" class="form-control" value="">
</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default"
data-dismiss="modal">取消
</button>
<button type="button" class="btn btn-primary" @click="importCommit">
确认
</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
后端是ssm框架
RequestMapping("/importExcel")
@RequiresPermissions("ship:shipinfo:importExcel")
public R importExcel(HttpServletRequest request){
SysUserEntity sysUser = getUser();
CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver(request.getServletContext());
multipartResolver.setDefaultEncoding("utf-8");
if(multipartResolver.isMultipart(request)) {
MultipartHttpServletRequest mutipart = (MultipartHttpServletRequest) request;
MultipartFile file = mutipart.getFile("uploadFile");
ExcelReader reader = new ExcelReader(file);
List<String[]> list = reader.readExcelData(1, null);
for(int i=1; i<list.size();i++) {
String[] strs = list.get(i);
Entity resultEntity = new Entity();
resultEntity.setShipName(strs[0]);
resultEntity.setShipNo(strs[1]);
................//设置字段属性
shipInfoService.insert(resultEntity);
}
} else {
throw new RRException("文件不存在");
}
return R.ok();
}