Search results
Please use this formula to change from Excel date to Unix date, then you can use "gmdate" to get the real date in PHP: UNIX_DATE = (EXCEL_DATE - 25569) * 86400 and to convert from Unix date to Excel date, use this formula: EXCEL_DATE = 25569 + (UNIX_DATE / 86400)
For a date, getValue () should return a float, which is the Excel serialized timestamp value for that date/time... I suspect it's your trim () that's casting it to string. The actual value is the number of days since 1/1/1900 (or 1/1/1904 depending on the calendar that the spreadsheet is using).
Excel functions that return a Date and Time value. Any of the Date and Time functions that return a date value in Excel can return either an Excel timestamp or a PHP timestamp or DateTime object. It is possible for scripts to change the data type used for returning date values by calling the ...
set_float_to_int($tf = false) — whether or not to parse excel cells with whole float numbers to integers. Often whole numbers are stored as float internally in XLS file, and by default they are parsed as floats. This setting allows to parse such numbers as integer type.
By default the dates will be parsed as a Carbon object (opens new window). You can disable date formatting completly inside import.php by setting dates.enabled to false . To enable/disable date formatting for a single import, use ->formatDates($boolean, $format)
16 mar 2023 · The Date::PHPToExcel() method will recognise most types that can be used for dates: a DateTime Object; an integer, which will be treated as a Unix Timestamp; or the string representation of a date.
4 maj 2021 · You can use setFormat() to format a date, ONLY IF the date is passed as an Excel numeric (int) or (float) date value. Several PHP libraries can convert a PHP date to an Excel numeric date value. Since our project uses both Spout and PhpSpreadsheet, we use PhpSpreadsheet’s Date::PHPToExcel() to convert a Carbon value to an Excel numeric value.
