<!--虎牌导入会员数据--> <a class="btn btn-primary btn-sm search-btn btn-wide btn-scroll btn-scroll-left ti-plus" ng-click="getHpOrderDate('lg')" has-permission="supplement_ag_game_report"><span>{{'hp_import_data' | translate}}</span></a><script type="text/ng-template" id="getHpDate"> <div class="modal-header"> <nav class="links cl-effect-2 cl-effect-2-spe"> <a href=""><span data-hover="{{hp_import_data}}">{{hp_import_data}}</span></a> </nav> <button type="button" class="close" ng-click="cancel()"><span aria-hidden="true">×</span></button> </div> <form role="form" class="form-horizontal" name="orderFormhp" ng-submit="submitFormhp(orderFormhp)" novalidate> <div class="modal-body"> <div class="form-group" ng-class="{'has-error':orderForm.importData.$dirty && orderForm.importData.$invalid, 'has-success':theForm.importData.$valid}"> <label class="col-sm-2 control-label" > {{'hp_import_data'| translate}} </label> <div class="col-sm-6 form-control-static"> <input type="file" placeholder="{{'hp_import_data' | translate}}" id="importData" name="importData" class="time_icon_calendar form-control" ng-model="importData" readonly="readonly"/> <span class="symbol required"></span> </div> <div class="col-sm-4"> <span class="error text-small block" ng-if="orderForm.importData.$dirty && orderForm.importData.$error.required">{{'hp_import_data' | translate}}{{'hp_import_data' | translate}}</span> </div> </div> </div> <div class="modal-footer"> <button class="btn btn-primary" type="submit" id="getHpOrderDateId">{{'button.ok' | translate}}</button> <button class="btn btn-primary btn-o" type="button" ng-click="cancel()">{{'button.cancel' | translate}}</button> </div> </form> </script>$.ajaxFileUpload({ async: true, url: "/hp_Game/importDate", type: 'post', dataType: 'JSON', fileElementId:'importData', success: function(data){ alert(data.code+"-----------"+data.msg); $translate(data.msg).then(function(msg) { SweetAlert.swal({ title: msg, type: data.code=='200'?'success':'error' }); if (data.code == '200') { $("#getHpOrderDateId").attr("disabled", true); $scope.cancel(); } }) }, error: function() { $modalInstance.close(); } });@RequestMapping(value = "importDate") @ResponseBody public Response getOrdertDate(HttpServletRequest request,MultipartFile importData){ //创建Excel工作薄 try { HSSFWorkbook hwb = new HSSFWorkbook(importData.getInputStream()); //得到第一个工作表 HSSFSheet sheet = hwb.getSheetAt(0); HSSFRow row = null; /**新版使用poi导入excel文件*/ Sheet sht0 = hwb.getSheetAt(0); for (Row r : sht0) { //如果当前行的行号(从0开始)未达到2(第三行)则从新循环 if (r.getRowNum() < 1) { continue; } String loginName = r.getCell(0).getStringCellValue(); String amount = r.getCell(3).getStringCellValue(); String birthday = r.getCell(8).getStringCellValue(); System.out.println("loginName:"+loginName+"--amount:"+amount+"--birthday:"+birthday); }}
web端实现表单提交poi导入excel文件
最新推荐文章于 2024-08-14 15:13:38 发布