thinkphp导入excel，日期格式化

    /*
       thinkphp导入excel
     */
    function getExcel($fileName,$headArr,$data){
        //导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
        import("Org.Util.PHPExcel");
        import("Org.Util.PHPExcel.Writer.Excel5");
        import("Org.Util.PHPExcel.IOFactory.php");

        //$date = date("Y_m_d",time());
        $fileName .= ".xls";

        //创建PHPExcel对象，注意，不能少了\
        $objPHPExcel = new \PHPExcel();
        $objProps = $objPHPExcel->getProperties();

        //设置表头
        $key = ord("A");
        $objPHPExcel->getActiveSheet()->getStyle('A')->getFont()->setName('宋体'); 
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
        //print_r($headArr);exit;
        foreach($headArr as $v){
            $colum = chr($key);
            $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);
            $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);
            $key += 1;
        }

        $column = 2;
        $objActSheet = $objPHPExcel->getActiveSheet();

        //print_r($data);exit;
        foreach($data as $key => $rows){ //行写入
            $span = ord("A");
            foreach($rows as $keyName=>$value){// 列写入
                $j = chr($span);
                $objActSheet->setCellValue($j.$column, $value);
                $span++;
            }
            $column++;
        }

        $fileName = iconv("utf-8", "gb2312", $fileName);

        //重命名表
        //$objPHPExcel->getActiveSheet()->setTitle('test');
        //设置活动单指数到第一个表,所以Excel打开这是第一个表
        $objPHPExcel->setActiveSheetIndex(0);
        ob_end_clean();//清除缓冲区,避免乱码
        header('Content-Type: application/vnd.ms-excel');
        header("Content-Disposition: attachment;filename=\"$fileName\"");
        header('Cache-Control: max-age=0');

        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output'); //文件通过浏览器下载
        exit;
    }
    
    
    //导入数据方法
    protected function goods_import($filename, $exts='xls')
    {
        //导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
        import("Org.Util.PHPExcel");
        //创建PHPExcel对象，注意，不能少了\
        $PHPExcel=new \PHPExcel();
        //如果excel文件后缀名为.xls，导入这个类
        if($exts == 'xls'){
            import("Org.Util.PHPExcel.Reader.Excel5");
            $PHPReader=new \PHPExcel_Reader_Excel5();
        }else if($exts == 'xlsx'){
            import("Org.Util.PHPExcel.Reader.Excel2007");
            $PHPReader=new \PHPExcel_Reader_Excel2007();
        }
 
        //载入文件
        $PHPExcel=$PHPReader->load($filename);
        //获取表中的第一个工作表，如果要获取第二个，把0改为1，依次类推
        $currentSheet=$PHPExcel->getSheet(0);
        //获取总列数
        $allColumn=$currentSheet->getHighestColumn();
        //获取总行数
        $allRow=$currentSheet->getHighestRow();
        //循环获取表中的数据，$currentRow表示当前行，从哪行开始读取数据，索引值从0开始
        for($currentRow=2;$currentRow<=$allRow;$currentRow++){
            //从哪列开始，A表示第一列
            for($currentColumn='A';$currentColumn<=$allColumn;$currentColumn++){
                //数据坐标
                $address=$currentColumn.$currentRow;
                //读取到的数据，保存到数组$arr中
                $cell =$currentSheet->getCell($address)->getValue();
              
                        if (preg_match('/^([$[A-Z]*-[0-9A-F]*])*[hmsdy]/i', $cell)) {
                            $cell=gmdate("Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($value));
                        }         这段是重点  日期格式化。如果excel里面不需要日期上传，可以把这段去掉 
                 //$cell = $data[$currentRow][$currentColumn];
                if($cell instanceof PHPExcel_RichText){
                    $cell  = $cell->__toString();
                }
                $data[$currentRow][] = $cell;
            }

        }
        //$this->save_import($data);
     return $data;
    } 
 

 以上代码我是放在  CommonController.class.php  控制器里面的。

文件导入控制器如下：

 

/年度爱心名录
class BenevolenceController extends CommonController
{

    function import(){
        if(IS_POST){
 
 
 
            
            $file = $_FILES['upfile'];
            $suffix = pathinfo($file['name'], PATHINFO_EXTENSION);
            if(!($suffix =='xls' || $suffix == 'xlsx')){
                $this->error('请选择Excel文件');
            }
            $data = $this->goods_import($file['tmp_name'],'xlsx');
    /*        import("Org.Util.PHPExcel.Shared.Date");
            $shared = new \PHPExcel_Shared_Date();*/
 
     
    //    dump($data);die;  
            
            if(!empty($data)){
                
                foreach ($data as $key => $value) {
                    $tmp = array();
                    $tmp['name'] = $value[0];
                    $tmp['phone'] = $value[1];
                    $tmp['address'] = $value[2];
                    $tmp['email'] = $value[3];
                    $tmp['use'] = $value[4];
                    $tmp['money'] = $value[5];
                    $tmp['updatetime']=$value[6];  
                        $tmp['is_show'] = 1;
                    $tmp['status'] = 1;
                    $tmp['create_time'] = time();
    // echo "<pre>";
    // print_r($tmp);die;
     
                    $rr=M('benevolence')->add($tmp);
                     
                }
                $this->success('导入成功',U('index'));
            }
        }else{
            $this->display();
        }
    }
}

 

注意 goods_import  这个类。