I am using Laravel excel (maatsweb excel v 2.1 https://docs.laravel-excel.com/2.1/import/dates.html) and laravel 5.5.
I have an issue when the field is date and there are 2 formats.
The first format is visible when opening the xcel with an xcel reader like LibreOffice. Lets say the user sees date as "02 Jan 2022"
The second format is visible when I click on the date cell - it shows another format. Lets say "01/02/2022"
When I call
$this->excelObj->get()
this returns one format (lets say "01/02/2022") But when I read the same file with
$this->excelObj->chunk(..
It returns the other format ("02 Jan 2022")
How can I have it read the same way? Is there a setting to make them behave the same?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire