PHPExcel读写封装类_PHP教程

　　初学者应该先去看示例，代码不是很难理解。方法名都是观其名，知其用。在看过些许例子的基础上，我才想到封装一下，用着方便。鉴于我自己也只是入门。所以写了个相对入门的封装。

 
 
  
 
 
  'Excel/Classes/PHPExcel.php' 
  myExcel      
             
      ; 
                 
               parent:: 
      
      
  '标题', 'creator' => '作者'); 
     
       setProperty(         ->objProperty = ->         (!(['creator']))->objProperty->setCreator(['creator'         (!(['title'])) ->objProperty->setTitle(['title'         (!(['subject']))->objProperty->setSubject(['subject'         (!(['laster']))->objProperty->setLastModifiedBy(['laster'         (!(['description']))->objProperty->setDescription(['description'         (!(['keyword']))->objProperty->setKeywords(['keyword'         (!(['category']))->objProperty->setCategory(['category'      
      
  'a111', 'b1'=>'b222', 'c1'=>'c111',); 
 
       addData(,  =           = ()? ->setActiveSheetIndex() : ->         (   =>              (() || ())              ->setCellValue(,        
     
       saveFile(,  = ,  = 'Excel5'         ->objWriter = PHPExcel_IOFactory::createWriter(,          
          = .         ->objWriter->save(      
 
     
     
       setReader(,  =          -> =          (             -> =              ->objReader = PHPExcel_IOFactory::createReader()->load(         }             -> = PHPExcel_IOFactory::identify(             ->objReader = PHPExcel_IOFactory::load(       
     
     
       loadFile(,  =          ->setReader(,          ->sheetData = ->objReader->getActiveSheet()->toArray(,,,      
     
       dataFormat(,  = 1,  =          (->sheetData   =>              ( &&  < )              ( &&  > )              (   =>                  ((,                      [][[]] =              (      
     
       sheetInfo( =          ()?  :  = ->          = ->objReader->listWorksheetInfo(                
  
 
 (  = './upImg/'  = .'aaa.xls' (!()) (, 0777, ) or ('上传目录创建失败！'  = ['files']['tmp_name' (, );
 
  =          'title'=>'the title',
         'creator' => '作者'
   =          'A1'=>'a1111',
         'A2'=>'a222',
         'B1'=>'b111',
         'E1'=>'e111',
         'f2'=>'f22222'
  
  =  
         'g2'=>'f22222',
         'h1'=>'hhh',
         'j1'=>'jjjjj'
  
  =  setProperty($property);
 addData($data, 0);
 addData($data2);
 saveFile('aaa.xls');
 
 ->loadFile('upImg/aaa.xls'  = ('A'=>'name','E'=>'age','F'=>'address'  = ->dataFormat(, , 5 (  ?>

数据返回的配置，可以看下图：

http://www.bkjia.com/PHPjc/440164.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/440164.htmlTechArticle对于 excel 文件的的生成于数据读取，我们可以用到 PHPExcel 插件。地址：http://phpexcel.codeplex.com/releases/view/107442 ，选第一个下载。然后解压的...