//作者：peking2009@gmail.com


include?__DIR__.?‘/PHPExcel/PHPExcel.php‘;

class?PHPExcelHelper{

????/**
?????*?根據(jù)模板導(dǎo)出文件，（完美支持：超過(guò)26列、公式、自定義多行模板頭、列顯示順序）
?????*?模板列字段要填寫(xiě)和data數(shù)組key對(duì)應(yīng)該上
?????*?@param?$saveFileName?要保存的文件名
?????*?@param?$templateFilePath?模板路徑絕對(duì)全路徑
?????*?@param?$data[]?要導(dǎo)出的數(shù)據(jù)
?????*?@return?string
?????*?@throws?\PHPExcel_Exception
?????*?@throws?\PHPExcel_Reader_Exception
?????*?@throws?\PHPExcel_Writer_Exception
?????*/
????public?static?function?exportByTemplate（$saveFileName?$data?$templateFilePath）
????{

????????$date?=?date（“Y_m_d“?time（））;
????????$saveFileName?.=?“_“?.?$date?.?“.xls“;
????????if?（!file_exists（$templateFilePath））?{
????????????echo?“模板文件不存在！“;
????????????return?“模板文件不存在！“;
????????}

????????$objReader?=?\PHPExcel_IO

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-05-20?17:49??PHPExcel\
?????目錄???????????0??2019-05-20?17:49??PHPExcel\PHPExcel\
?????文件????????3226??2018-11-12?09:23??PHPExcel\PHPExcel\Autoloader.php
?????目錄???????????0??2019-05-20?17:49??PHPExcel\PHPExcel\CachedobjectStorage\
?????文件???????10188??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\APC.php
?????文件???????10195??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\Cachebase.php
?????文件????????6619??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\DiscISAM.php
?????文件????????3513??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\ICache.php
?????文件????????4709??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\Igbinary.php
?????文件????????9935??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\Memcache.php
?????文件????????3880??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\Memory.php
?????文件????????4360??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\MemoryGZip.php
?????文件????????4350??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\MemorySerialized.php
?????文件????????6320??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\PHPTemp.php
?????文件????????9839??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\SQLite.php
?????文件???????10644??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\SQLite3.php
?????文件????????9206??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorage\Wincache.php
?????文件????????8620??2018-11-12?09:23??PHPExcel\PHPExcel\CachedobjectStorageFactory.php
?????目錄???????????0??2019-05-20?17:49??PHPExcel\PHPExcel\CalcEngine\
?????文件????????2394??2018-11-12?09:23??PHPExcel\PHPExcel\CalcEngine\CyclicReferenceStack.php
?????文件????????4133??2018-11-12?09:23??PHPExcel\PHPExcel\CalcEngine\Logger.php
?????目錄???????????0??2019-05-20?17:49??PHPExcel\PHPExcel\Calculation\
?????文件???????28658??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\Database.php
?????文件???????57498??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\DateTime.php
?????文件??????100942??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\Engineering.php
?????文件????????1712??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\Exception.php
?????文件????????1625??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\ExceptionHandler.php
?????文件???????89982??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\Financial.php
?????文件???????22765??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\FormulaParser.php
?????文件????????5687??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\FormulaToken.php
?????文件????????4142??2018-11-12?09:23??PHPExcel\PHPExcel\Calculation\Function.php
............此處省略276個(gè)文件信息