<?php

   namespace Think\Model;//自己新建一个model类

   use Think\Model;

   class ExcelModel extends Model {

   protected $tableName = 'products_log';

   public function __construct() {

     /*导入phpExcel核心类 SPAPP_PATH为存放phpexcel路径的定义，在入口文件index.php定义*/

   require_once SPAPP_PATH.'Core/Library/Vendor/PHPExcel/PHPExcel.php';

   require_once SPAPP_PATH.'Core/Library/Vendor/PHPExcel/PHPExcel/Writer/Excel5.php';     // 用于其他低版本xls

   require_once SPAPP_PATH.'Core/Library/Vendor/PHPExcel/PHPExcel/Writer/Excel2007.php'; // 用于 excel-2007 格式

   }

 //导入excel内容转换成数组，import方法要用到

 public function import($filePath){

   $this->__construct();

   $PHPExcel = new \PHPExcel();//实例化，一定要注意命名空间的问题加\ 

   /**默认用excel2007读取excel，若格式不对，则用之前的版本进行读取*/

   $PHPReader = new \PHPExcel_Reader_Excel2007();

     if(!$PHPReader->canRead($filePath)){

       $PHPReader = new \PHPExcel_Reader_Excel5();

       if(!$PHPReader->canRead($filePath)){

         echo 'no Excel';

         return;

       }

     } 

   $PHPExcel = $PHPReader->load($filePath);

   $currentSheet = $PHPExcel->getSheet(0);  //读取excel文件中的第一个工作表

   $allColumn = $currentSheet->getHighestColumn(); //取得最大的列号

   $allRow = $currentSheet->getHighestRow(); //取得一共有多少行

   $erp_orders_id = array();  //声明数组

   /**从第二行开始输出，因为excel表中第一行为列名*/

   for($currentRow = 2;$currentRow <= $allRow;$currentRow++){ 

       /**从第A列开始输出*/

     for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){

    //这部分注释不要，取出的数据不便于我们处理

    // $val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();/**ord()将字符转为十进制数*/

    //  if($val!=''){

    //  $erp_orders_id[] = $val;

    //  }

    //数据坐标

             $address = $currentColumn . $currentRow;

             //读取到的数据，保存到数组$arr中

             $data[$currentRow][$currentColumn] = $currentSheet->getCell($address)->getValue();

     /**如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将gb2312编码转为utf-8编码输出*/

     //echo iconv('utf-8','gb2312', $val)."\t"; 

   }

   }

   return $data;

 }

 <form method="post" class="form-horizontal js-ajax-form" action="{:U('Student/student_excelpost')}" enctype="multipart/form-data">

             <fieldset>

                 <div class="control-group">

                     <label class="control-label">导入excel文件:</label>

                     <div class="controls">

                         <input type="file" name="file_stu">

                         <span class="form-required">*</span>

                     </div>

                 </div>

             </fieldset>

             <div class="form-actions">

                 <button type="submit" class="btn btn-primary js-ajax-submit">导入</button>

             </div>

 </form>

 //表格数据

     public function student_excelpost(){

         //获取上传的文件名、扩展名等信息

      if (! empty ( $_FILES ['file_stu'] ['name'] ))

      {

         //保存的是文件上传到服务器临时文件夹之后的文件名

         $tmp_file = $_FILES ['file_stu'] ['tmp_name'];

         //分割文件名和扩展名

         $file_types = explode ( ".", $_FILES ['file_stu'] ['name'] );

         //获取扩展名

         $file_type = $file_types [count ( $file_types ) - 1];

      /*判别是不是.xls文件，判别是不是excel文件*/

      if (strtolower ( $file_type ) != "xlsx" && strtolower ( $file_type ) != "xls")

      {

        $this->error ( '不是Excel文件，重新上传' );

      }

     /*设置上传路径*/

      $savePath = Excel_PATH.'Excel/';

     /*以时间来命名上传的文件*/

      $str = date ( 'Ymdhis' );

      $file_name = $str . "." . $file_type;

      /*是否上传成功*/

      if (! copy ( $tmp_file, $savePath . $file_name ))

       {

         $this->error ( '上传失败' );

       }

     }

     $data = D("Think/Excel")->import( $savePath . $file_name );

     $res = array();  //声明数组

     // echo'<pre>';

     // var_dump($data);

     // exit;

     //查询user表,对应信息相互关联

     foreach($data as $i=>$val){

         // var_dump($val[B]);

         $s['class_name'] = $val[A];

         $s['student_name'] = $val[B];

         $s['student_number'] = $val[C];

         $s['student_tel'] = $val[D];

         if($val[E] == '男'){

             $s['student_sex'] = 1;

         }else{

             $s['student_sex'] = 0;

         }

         $s['student_birthday'] = $val[F];

         $s['student_national'] = $val[G];

         $s['student_native'] = $val[H];

         $s['student_email'] = $val[I];

         $s['student_from'] = $val[J];

         $s['student_alone'] = $val[K];

         $s['student_exp'] = $val[L];

         $s['student_think'] = $val[M];

         $s['student_love'] = $val[N];

         $s['student_tschool'] = $val[O];

         $s['student_tmajor'] = $val[P];

         $s['student_contact'] = $val[Q];

         $s['student_consider'] = $val[R];

         $s['student_affect'] = $val[S];

         $s['student_imp'] = $val[T];

         // echo'<pre>';

         // var_dump($s);$this->student_model(为数据库实例，本人在上面定义这里可以直接拿过来用)

         $rs = $this->student_model->add($s);

     }

         if($rs){

             $this->success("数据添加成功！", U('Student/student'));

         }else{

             $this->error("数据添加失败！");

         }

         // exit;

     }

 }