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

<!--虎牌导入会员数据-->
<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">&times;</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);
        }
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值