Excel导入功能的前后端案例

前端导入使用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>&nbsp;导入</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();
    }