phpExcel 导入导出

  /** 
         * 导入
         * @param  string  $filePath   
         * @param  integer $sheet    
         */  
        public function leading($filePath='',$sheet=0){  
            $Reader = new PHPExcel_Reader_Excel2007();  
            $PHPExcel = $Reader->load($filePath);
            $Sheet = $PHPExcel->getSheet($sheet);
            $Column = $Sheet->getHighestColumn();
            $Column= PHPExcel_Cell::columnIndexFromString($Column);
            $Row = $Sheet->getHighestRow();
            $data = array();  
            for($i = 2;$i <= $Row; $i++){
                for($j = 0;$j < $Column;$j++){  
                    $col = PHPExcel_Cell::stringFromColumnIndex($j);  
                    $addr = $col.$i;  
                    $cell = $Sheet->getCell($addr)->getValue();
                    if($cell instanceof PHPExcel_RichText){ 
                        $cell = $cell->__toString();  
                    }  
                    $data[$i][$col] = $cell;  
                }  
            }  
            return $data;  
        }  

        /** 
         * 导出 
         * @param  array  $title    
         * @param  array  $data       
         * @param  string $filename   
         * @return string            
         */  
        public function derive($title=[],$data=[],$filename=''){ 
            if(empty($filename) || empty($data)){ 
               return false;   
            }   
            $resultPHPExcel = new PHPExcel();   
            foreach ($title as $key => $val) {  
                 $resultPHPExcel->getActiveSheet()->setCellValue($key.'1', $val);   
            }  
            if(!empty($data)){  
                foreach ($data as $key => $val) {  
                    $index = $key + 2;
                    foreach ($val as $ke => $va) {  
                        $resultPHPExcel->getActiveSheet()->setCellValue($ke.$index, $va);   
                    }  
                }  
            }  
            header('Cache-Control: max-age=0');
            $objWriter = PHPExcel_IOFactory::createWriter($resultPHPExcel, 'Excel2007');  
            $objWriter->save($filename);  
            return realpath($filename);  
        }  

调用

      $excel= new PHPExcel();
      $file_path=$excel->export($title,$excel_data);

传递对应的参数。 第一个为 要设置的标题，第二为要设置的数据，第三个是 保存文件的路径