phpExcel 生成快递单

最新推荐文章于 2021-03-26 15:29:53 发布

FatTiger、

最新推荐文章于 2021-03-26 15:29:53 发布

阅读量2.7k

点赞数

分类专栏： PHP 文章标签： phpExcel 快递单生成

本文链接：https://blog.csdn.net/zhaoerduo/article/details/45691501

版权

PHP 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

require_once 'PHPExcel.php';

        //定义路径

        $filePath = UPLOAD_PATH.'/shiptemplate/yt_excel.xls';
        $objPHPExcel = PHPExcel_IOFactory::load($filePath);
        $raw_data = $objPHPExcel->setActiveSheetIndex(0)->toArray();

        $data = array();
        $pname = '';
        foreach($n_ship as $nk=>$nval){
            for($i=0; $i<count($nval['product_name']); $i++){
                if(!$i){
                    $pname = $nval['product_name'][$i];
                }else{
                    $pname .= ",".$nval['product_name'][$i];
                }
            }
            foreach($raw_data as $key => $value){
                foreach($value as $k => $v){
                    if($v == "{% company %}"){
                        $value[$k] = str_replace('{% company %}', '轻轻去去去', $v);
                    }elseif($v == "{% f_address %}"){
                        $value[$k] = str_replace('{% f_address %}', '恩恩额', $v);
                    }elseif($v == "{% consignee %}"){
                        $value[$k] = str_replace('{% consignee %}', 点点滴滴, $v);
                    }elseif($v == "{% f_telephone %}"){
                        $value[$k] = str_replace('{% f_telephone %}', '15031456789', $v);
                    }elseif($v == "{% product_name %}"){
                        $value[$k] = str_replace('{% product_name %}', $pname, $v);
                    }elseif($v == "{% t_address %}"){
                        $value[$k] = str_replace('{% t_address %}', $nval['address'], $v);
                    }elseif($v == "{% telephone %}"){
                        $value[$k] = str_replace('{% telephone %}', $nval['telephone'], $v);
                    }elseif($v == "{% c_time %}"){
                        $value[$k] = str_replace('{% c_time %}', date("Y/m/d",time()), $v);
                    }elseif($v == "{% s_address %}"){
                        $value[$k] = str_replace('{% s_address %}', " ", $v);
                    }elseif($v == "{% t_company %}"){
                        $value[$k] = str_replace('{% t_company %}', " ", $v);
                    }
                }

                $reset_key = 0;
                if ($nk){
                    $reset_key = count($data)+10;
                }
                $data[$reset_key+$key] = $value;
            }
        }
        $objPHPExcel->setActiveSheetIndex()->fromArray($data, null, "A1");

        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        ob_end_clean();
        $cancel_time="KD".date("YmdHis");
        if(!file_exists('upload/excel')){
            mkdir( 'upload/excel' , 0777 , true );
        }
        $filename = "upload/excel/".$cancel_time."_ship.xls";
        $objWriter->save($filename);