91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1.56M
    文件類型: .zip
    金幣: 1
    下載: 0 次
    發布日期: 2021-01-29
  • 語言: PHP
  • 標簽: 數據庫??文件??php??

資源簡介

主要是解析表格文件轉成數組進行入庫

資源截圖

代碼片段和文件信息


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個文件信息

評論

共有 條評論