【thinkphp利用phpexcel实现导入excel】thinkphp利用phpexcel实现导入excel

【www.bbyears.com--thinkphp】

 1.上传excel文件。

2.读取excel中的数据到数据库中

那么我们就从第一步开始

上传excel代码：

html部分：

   
   
   
   
   
   

执行代码：

        class IndexAction extends Action {
        public function index(){
            $this->display();
        }
        public function upload()
        {
            import("ORG.Net.UploadFile");
            if(!empty($_FILES["photo"]["name"]))
            {
                $upload = new UploadFile();
                $upload->maxSize  = 93145728 ;
                $upload->saveRule =time;
                $upload->allowExts  = array("xls","xlsx");
                $upload->savePath =  "./Uploads/";
                if(!$upload->upload())
                {
                    $this->error($upload->getErrorMsg());
                }else{
                    $info =  $upload->getUploadFileInfo();
                } www.111cn.net

                //下面就是我们说的第二步了
                import("ORG.Excel.PHPExcel");
                $file_name=$info[0]["savepath"].$info[0]["savename"];
                $objReader = PHPExcel_IOFactory::createReader("Excel5");
                $objPHPExcel = $objReader->load($file_name,$encode="utf-8");
                $sheet = $objPHPExcel->getSheet(0);
                $highestRow = $sheet->getHighestRow(); // 取得总行数
                $highestColumn = $sheet->getHighestColumn(); // 取得总列数
                for($i=2;$i<=$highestRow;$i++)
                {
                    $name = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();
                    $old = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
                    $sex = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();
                    $ID    = $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();
                    $guoji = $objPHPExcel->getActiveSheet()->getCell("E".$i)->getValue();
                    $minzu = $objPHPExcel->getActiveSheet()->getCell("F".$i)->getValue();
                    $address = $objPHPExcel->getActiveSheet()->getCell("G".$i)->getValue();
                }
                echo $name."//".$old."//".$sex."//".$ID."//".$guoji."//".$minzu."//".$address;exit;
            }else
            {
                $this->error("请选择上传的文件");
            }       
        }
    }

效果图：

导入数据库和平常的入库代码一样。

本文来源：http://www.bbyears.com/jiaocheng/51542.html