这篇文章主要介绍了关于如何利用PHP导入Excel数据到数据库，有着一定的参考价值，现在分享给大家，有需要的朋友可以参考一下

    /**     * 导入excel     * @throws \PHPExcel_Exception     * @throws \PHPExcel_Reader_Exception     */    public function impExcel($filename,$data){        if (!empty($_FILES)) {            $config = array(                &#39;exts&#39;=>array(&#39;xlsx&#39;,&#39;xls&#39;),                &#39;rootPath&#39;=>"./",                &#39;savePath&#39;=> "Public/Uploads/$filename/",                &#39;subName&#39;    =>    array(&#39;date&#39;,&#39;Ymd&#39;),            );            $upload = new \Think\Upload($config);            if (!$info=$upload->upload()) {                $this->error($upload->getError());            }            vendor("PHPExcel.PHPExcel");            $file_name = $info[&#39;excel&#39;][&#39;savepath&#39;].$info[&#39;excel&#39;][&#39;savename&#39;];            //$objReader = \PHPExcel_IOFactory::createReader(&#39;Excel5&#39;);            $Excel_name = getcwd() . &#39;/&#39; .$file_name;            //$aaa = is_readable($Excel_name);           // $objPHPExcel = $objReader->load($Excel_name,$encode=&#39;utf-8&#39;);            $extension = strtolower( pathinfo($Excel_name, PATHINFO_EXTENSION) );            if ($extension ==&#39;xlsx&#39;) {                $objReader = new \PHPExcel_Reader_Excel2007();                $objPHPExcel = $objReader ->load($Excel_name);            } else if ($extension ==&#39;xls&#39;) {                $objReader = new \PHPExcel_Reader_Excel5();                $objPHPExcel = $objReader ->load($Excel_name);            } else if ($extension==&#39;csv&#39;) {                $PHPReader = new \PHPExcel_Reader_CSV();                //默认输入字符集                $PHPReader->setInputEncoding(&#39;GBK&#39;);                //默认的分隔符                $PHPReader->setDelimiter(&#39;,&#39;);                //载入文件                $objPHPExcel = $PHPReader->load($Excel_name);            }            $sheet = $objPHPExcel->getSheet(0);            $highestRow = $sheet->getHighestRow(); // 取得总行数            $highestColumn = $sheet->getHighestColumn(); // 取得总列数            for($i=2;$i<=$highestRow;$i++)            {                $data[&#39;name&#39;] = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getvalue();                $data[&#39;tel&#39;] = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();                $data[&#39;zjh&#39;]    = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();                $data[&#39;sheng&#39;] = $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();                $data[&#39;shi&#39;] = $objPHPExcel->getActiveSheet()->getCell("E".$i)->getValue();                $data[&#39;address&#39;]= $objPHPExcel->getActiveSheet()->getCell("F".$i)->getValue();                $data[&#39;money&#39;]= $objPHPExcel->getActiveSheet()->getCell("G".$i)->getValue();                $data[&#39;hk_time&#39;]= $objPHPExcel->getActiveSheet()->getCell("H".$i)->getValue();                $data[&#39;nanyi&#39;]= $objPHPExcel->getActiveSheet()->getCell("I".$i)->getValue();                $data[&#39;uid&#39;] = $_SESSION[&#39;user&#39;][&#39;id&#39;];                $data[&#39;time&#39;] = date("Y-m-d H:i:s");                M(&#39;release&#39;)->add($data);            }            $this->success(&#39;导入成功！&#39;);exit();        }else        {            $this->error("请选择上传的文件");        }    }

调用：

 if(IS_POST)        {            $data['reason'] = I("post.reason","","trim");            $data['type'] = I("post.type","","trim");           // $data['qixian'] = I("post.qixian","","trim");           // $data['comm'] = I("post.comm","","trim");            if(!empty($_FILES)){                $this->impExcel('batch_release',$data);            }        }

相关推荐：

利用PHPEXCEL 导出数据和图片的代码   

标签： excel数据库教程