For the php excel reading problem, after using the PHPexcel class to read an excel file, if the column in the excel file is of the date type, the date value cannot be displayed normally. How can I enable PHP to automatically determine whether the column to be read is of the date type? if it is of the date type, convert it to a value that can be normally displayed through the conversion function. ------ Solution -------------------- I have done this. I 'd like to give you a function and give it a try. previously I found the issue of PH reading excel from php on the Internet.
After reading an excel file in PHP excel, if the column in the excel file is of the date type, the date value cannot be displayed normally. How can I enable PHP to automatically determine whether the column to be read is of the date type? if it is of the date type, convert it to a value that can be normally displayed through the conversion function.
------ Solution --------------------
I have done this. I want to give you a function. I used to find it online.
PHP code
// Excel date conversion function excelTime ($ days, $ time = false) {if (is_numeric ($ days) {// based on 1900-1-1 $ jd = GregorianToJD (1, 1, 1970); $ gregorian = JDToGregorian ($ jd + intval ($ days)-25569); $ myDate = explode ('/', $ gregorian ); $ myDateStr = str_pad ($ myDate [2], 4, '0', STR_PAD_LEFT ). "-". str_pad ($ myDate [0], 2, '0', STR_PAD_LEFT ). "-". str_pad ($ myDate [1], 2, '0', STR_PAD_LEFT ). ($ time? "00:00:00": ''); return $ myDateStr;} elseif (strpos ($ days ,'.')! = 0) {return str_replace ('.', '-', $ days);} return $ days ;}