從github下載PHPExcel [PHPExcel](https://github.com/PHPOffice/PHPExcel) 將下載好的PHPExcel文件夾跟PHPExcel放置在框架中的Vendor目錄下，注意目錄的結構  ## 前端代碼： ``` <form class="layui-form" method="post" action="" enctype="multipart/form-data"> <div class="layui-form-item"> <label class="layui-form-label">示例文件</label> <div class="layui-input-inline"> <a href="{$company}">下載文件</a> </div> <div class="layui-form-mid layui-word-aux">下載示例文件修改內容，開始導入</div> </div> <div class="layui-form-item"> <label class="layui-form-label">所屬區域</label> <div class="layui-input-inline"> <select name="areaid" lay-verify="required"> {volist name="area" id="vo"} <option value="{$vo.id}">{$vo.name}</option> {/volist} </select> </div> </div> <div class="layui-form-item"> <label for="portdata" class="layui-form-label"> <span class="x-red">*</span>選擇文件 </label> <div class="layui-input-inline"> <input type="file" id="portdata" name="portdata" required="" lay-verify="required" autocomplete="off" class="layui-input"> </div> </div> <div class="layui-form-item"> <label for="L_repass" class="layui-form-label"> </label> <button class="layui-btn" lay-filter="add" lay-submit=""> 開始導入 </button> </div> </form> ``` ## 導入功能控制器的代碼 ``` public function qyimport(){ $where = $this->areawhere('id'); $area=Db::name('area')->where($where)->select(); if (Request::instance()->isPost()){ // $postdata=Request::instance()->param(); vendor("PHPExcel.PHPExcel"); $objPHPExcel =new \PHPExcel(); //獲取表單上傳文件 $file = request()->file('portdata'); $info = $file->validate(['ext' => 'xlsx'])->move(ROOT_PATH . 'public/uploads'); //上傳驗證后綴名,以及上傳之后移動的地址 E:\wamp\www\bick\public if($info) { // echo $info->getFilename(); $exclePath = $info->getSaveName(); //獲取文件名 $file_name = ROOT_PATH . 'public/uploads' . DS . $exclePath;//上傳文件的地址 $objReader =\PHPExcel_IOFactory::createReader("Excel2007"); $obj_PHPExcel =$objReader->load($file_name, $encode = 'utf-8'); //加載文件內容,編碼utf-8 // file_put_contents('C:/log.html',' file_name:'.$file_name.'<br>',FILE_APPEND); $excel_array=$obj_PHPExcel->getSheet(0)->toArray(); //轉換為數組格式 array_shift($excel_array); //刪除第一個數組(標題); $city = []; $i=0; $time = time(); $areaid = input('param.areaid'); foreach($excel_array as $k=>$v) { $name = trim($v[0]); if(!empty($name)){ $checkqiye=Db::name('qiye')->where(array('name'=>$name))->find(); if(empty($checkqiye)){ $indata = array( 'name'=>$name, 'xinyongdm'=>trim($v[1]), 'legalperson'=>trim($v[2]), 'address'=>trim($v[3]), 'regdate'=>trim($v[4]), 'lperson'=>trim($v[5]), 'phone'=>trim($v[6]), 'zztype'=>trim($v[7]), 'zzbdate'=>trim($v[8]), 'axzheng'=>trim($v[9]), 'addtime'=>$time, 'areaid'=>$areaid ); Db::name('qiye')->insert($indata); } } $i++; } $this->success('導入成功','qiyelist'); }else{ echo $file->getError(); } } $company = request()->domain().'/case/case.xlsx'; $this->assign('company',$company); $this->assign('area',$area); return $this->fetch(); } ```