EXcel 上传更新

$suffix= strrchr($_FILES['file_path']['name'],'.');
        $xl = array('.xls');
        if(!in_array($suffix,$xl)){
            echo "{success:false,msg:'文件错误,文件只能是xls文件'}";exit;
        }
        set_time_limit(0);
        include_once(CFG_PATH_LIB.'PHPExcel/Reader/Excel5.php');
        $objReader = new PHPExcel_Reader_Excel5();
        $objReader->setReadDataOnly(true);
        $objPHPExcel = $objReader->load($_FILES['file_path']['tmp_name']);
        $currentSheet =$objPHPExcel->getSheet(0);
        $allColumn = $currentSheet->getHighestColumn();
        $allRow = $currentSheet->getHighestRow();
        $field_list = array();
        $object = new ModelGoods();
        $msg = '';

        if($currentSheet->getCell("A1")->getValue() != 'goods_sn') {echo "{success:false,msg:'文件格式错误'}";exit;}
        for($currentColumn='B';$currentColumn<=$allColumn;$currentColumn++){ //第一行取更新字段
            $field_list[] = trim($currentSheet->getCell($currentColumn."1")->getValue());
        }
        $err = 0;
        for($currentRow = 2;$currentRow<=$allRow;$currentRow++){//从第二行开始更新数据
            $goods_info = array();
            $filed_value = array();
            for($currentColumn='B';$currentColumn<=$allColumn;$currentColumn++){
                $address = $currentColumn.$currentRow;
                $filed_value[] = trim($currentSheet->getCell($address)->getValue());
            }
            for($i=0;$i<count($field_list);$i++){
                $goods_info[$field_list[$i]] = $filed_value[$i];
            }
            try {
                $object->updategoods($goods_info,trim($currentSheet->getCell("A".$currentRow)->getValue()));
            } catch (Exception $e) {
                $err =1;
                $msg .= $currentSheet->getCell("A".$currentRow)->getValue().'产品数据保存失败<br>';
            }
        }
        if($err == 1) {echo "{success:false,msg:'$msg'}";exit;}
        savelog($_SESSION['admin_id'],'goods','批量更新产品信息',$_SESSION['admin_id']);
        echo "{success:true,msg:'产品更新成功'}";exit;
    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值