Example of php reading excel date data

The date in Excel, after being read by php, is converted into a number similar to 25569, instead of the 1970-1-1 character format displayed in Excel. the date in the original excel is a number format starting from-1, for example, 1900-1 -... the date in Excel, after being read by php, is converted into a number similar to 25569, instead of the 1970-1-1 character format displayed in Excel. the date in the original excel is a number format starting from-1, for example, if 25569-1-1 is 1,-1-1 is.

Provides a read function with the following code:

 25568? $ Date + 1: 25569;/* There was a bug if Converting date before 1-1-1970 (tstamp 0) */$ ofs = (70*365 + 17 + 2) * 86400; $ date = date ("Y-m-d", ($ date * 86400)-$ ofs ). ($ time? "00:00:00": '');} return $ date ;}

Article link:

Save this article for favorites!