PHPExcel 读写封装类

PHPExcel 读写封装类

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

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

 <form  method="post" enctype="multipart/form-data" >
 
 文件：<input type="file" name="files" /></li>
 <input type="submit" value="提交" />
 </form>
 
 <? 
 
 
  'Excel/Classes/PHPExcel.php' 
  myExcel      
             
      ; 
                 
               parent:: 
      
      
       
       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'      
      
   
       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'
  
  =     
 
 ->loadFile('upImg/aaa.xls'  = ('A'=>'name','E'=>'age','F'=>'address'  = ->dataFormat(, , 5 (  ?>

 

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