資源簡介
主要是解析表格文件轉成數組進行入庫
代碼片段和文件信息
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\Cachedob
?????文件????????9548??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????目錄???????????0??2017-11-09?08:55??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件???????10594??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????6776??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????3484??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????4862??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件???????10709??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????3800??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????4333??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????4319??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件????????6451??2017-03-02?08:38??php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
?????文件?????????172??2017-03-02?08:38??__MACOSX\php璇誨彇琛ㄦ牸鏂囦歡\Classes\PHPExcel\Cachedob
............此處省略663個文件信息
- 上一篇:微擎商業破解版1.7.3安裝包
- 下一篇:php生成字符數字、文字、算術驗證碼
評論
共有 條評論