require_once?‘Classes/PHPExcel.php‘;

/**對(duì)excel里的日期進(jìn)行格式轉(zhuǎn)化*/
function?GetData（$val）
{
????$jd?=?GregorianToJD（1?1?1970）;
????$gregorian?=?JDToGregorian（$jd?+?intval（$val）?-?25569）;
????return?$gregorian;
????/**顯示格式為?“月/日/年”?*/
}

$filePath?=?‘report.xls‘;

$PHPExcel?=?new?PHPExcel（）;

/**默認(rèn)用excel2007讀取excel，若格式不對(duì)，則用之前的版本進(jìn)行讀取*/
$PHPReader?=?new?PHPExcel_Reader_Excel2007（）;
if?（!$PHPReader->canRead（$filePath））?{
????$PHPReader?=?new?PHPExcel_Reader_Excel5（）;
????if?（!$PHPReader->canRead（$filePath））?{
????????echo?‘no?Excel‘;
????????return;
????}
}

$PHPExcel?=?$PHPReader->load（$filePath）;
/**讀取excel文件中的第一個(gè)工作表*/
$currentSheet?=?$PHPExcel->getSheet（0）;
/**取得最大的列號(hào)*/
$allColumn?=?$currentSheet->getHighestColumn（）;
/**取得一共有多少行*/
$allRow?=?$currentSheet->

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-09?08:54??php璇誨彇琛ㄦ牸鏂囦歡\
?????目錄???????????0??2017-11-09?08:23??php璇誨彇琛ㄦ牸鏂囦歡\Classes\
?????目錄???????????0??2017-11-09?08:30??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\
?????文件????????2884??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Autoloader.php
?????目錄???????????0??2017-11-09?08:55??__MACOSX\
?????目錄???????????0??2017-11-09?08:55??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\
?????目錄???????????0??2017-11-09?08:55??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\
?????目錄???????????0??2017-11-09?08:55??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\._Autoloader.php
?????目錄???????????0??2017-11-09?08:30??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\
?????文件????????9548??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\APC.php
?????目錄???????????0??2017-11-09?08:55??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._APC.php
?????文件???????10594??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\Cachebase.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._Cachebase.php
?????文件????????6776??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\DiscISAM.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._DiscISAM.php
?????文件????????3484??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\ICache.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._ICache.php
?????文件????????4862??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\Igbinary.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._Igbinary.php
?????文件???????10709??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\Memcache.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._Memcache.php
?????文件????????3800??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\Memory.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._Memory.php
?????文件????????4333??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\MemoryGZip.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._MemoryGZip.php
?????文件????????4319??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\MemorySerialized.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._MemorySerialized.php
?????文件????????6451??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\PHPTemp.php
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\CachedobjectStorage\._PHPTemp.php
............此處省略663個(gè)文件信息