web端实现表单提交poi导入excel文件

﹏ヽ暗。殇╰゛Y 2022-07-11 11:16 109阅读 0赞

<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);
            }}