PHPExcel 讀寫封裝類_PHP教程

　　對於 excel 檔案的的產生於資料讀取，我們可以用到 PHPExcel 外掛程式。地址：http://phpexcel.codeplex.com/releases/view/107442 ，選第一個下載。然後解壓的檔案目錄如下：

　　初學者應該先去看樣本，代碼不是很難理解。方法名都是觀其名，知其用。在看過些許例子的基礎上，我才想到封裝一下，用著方便。鑒於我自己也只是入門。所以寫了個相對入門的封裝。

        '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 ，選第一個下載。然後解壓的...

