Importing xlsx file shows different data format #4087
Answered
by
patrickbrouwers
gab-logicbase
asked this question in
Q&A
-
I'm trying to upload the following xlsx file but when I debug the imported values it shows floating numbers |
Beta Was this translation helpful? Give feedback.
Answered by
patrickbrouwers
Feb 15, 2024
Replies: 1 comment 1 reply
-
This is how Excel stores those kind of things behind the scenes, you have to convert it to format you want, like with |
Beta Was this translation helpful? Give feedback.
1 reply
Answer selected by
gab-logicbase
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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)