Skip to content

Importing xlsx file shows different data format #4087

Discussion options

You must be logged in to vote

This is how Excel stores those kind of things behind the scenes, you have to convert it to format you want, like with
\PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($excelDate) or \PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimeStamp($excelDate)

Replies: 1 comment 1 reply

Comment options

You must be logged in to vote
1 reply
@gab-logicbase
Comment options

Answer selected by gab-logicbase
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants