PHP表格文件导入到数据库（读取excle文件内容）

主要是解析表格文件转成数组进行入库

require_once ‘Classes/PHPExcel.php‘;

/**对excel里的日期进行格式转化*/
function GetData（$val）
{
    $jd = GregorianToJD（1 1 1970）;
    $gregorian = JDToGregorian（$jd + intval（$val） - 25569）;
    return $gregorian;
    /**显示格式为 “月/日/年” */
}

$filePath = ‘report.xls‘;

$PHPExcel = new PHPExcel（）;

/**默认用excel2007读取excel，若格式不对，则用之前的版本进行读取*/
$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文件中的第一个工作表*/
$currentSheet = $PHPExcel->getSheet（0）;
/**取得最大的列号*/
$allColumn = $currentSheet->getHighestColumn（）;
/**取得一共有多少行*/
$allRow = $currentSheet->

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           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个文件信息